Solution: You don't need to do this:UPDATE TableASET ClientSurname = LEFT(ClientName,CHARINDEX(',',ClientName))UPDATE TableASET ...
確定! 回上一頁