您如何将数据从一列拆分为两列？

从…开始

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