****************************************************************

'NAME FLIP

'Smith, Jeff

****************************************************************

UPDATE tbl_OfficeDir

SET             

namepart1 = (select substring(Name, CHARINDEX(',', Name) + 2, len(name) )FROM      tbl_OfficeDir a where tbl_OfficeDir.id = a.id)

UPDATE    tbl_OfficeDir

SET 

namepart2 = (select right(Name, CHARINDEX(',', Name) + 1) FROM  tbl_OfficeDir a where tbl_OfficeDir.id = a.id)