sql command to remove spaces from a entire column values code example

Example 1: sql update table remove spaces

LTRIM(RTRIM(ColumnName))

Example 2: remove spaces sql 2008

SELECT RTRIM(LTRIM(' Word '))