Select TRIM (' Word ')
update table set CompanyName = LTRIM(RTRIM(CompanyName))
SELECT REPLACE(' Hello World ',' ')