update Tilmax
set CleanAreaCode = left( phone, 3 ),
CleanPhone = substring( phone, 4, 7 ),
CleanExtension = substring( phone, 11, 25 )
SELECT *
from Tilmax
where cleanName is null
update tilmax
set cleanName =
where loadId =
| #name# | #cleanedName# | #city# |