remove space from column sql server code example
Example 1: space not removing from column in sql
update thetable set thecolumn = rtrim(replace(thecolumn, char(160), char(32)))
Example 2: remove spaces sql 2008
SELECT RTRIM(LTRIM(' Word '))
update thetable set thecolumn = rtrim(replace(thecolumn, char(160), char(32)))
SELECT RTRIM(LTRIM(' Word '))