UPDATE students SET studentname = left(studentname, InStr(StudentName," ")-1) & ', ' & Trim(right(studentname, len(studentname) - instr(studentname, " ")));