从…开始
memberID LastFirstName LastName FirstName
-------- ------------- -------- ---------
1 Doe, John
UPDATE Members SET
LastName = Trim(Left(LastFirstName, InStr(LastFirstName, ",") - 1)),
FirstName = Trim(Mid(LastFirstName, InStr(LastFirstName, ",") + 1))
将导致
memberID LastFirstName LastName FirstName
-------- ------------- -------- ---------
1 Doe, John Doe John