add space in sql server code example

Example 1: sql update table remove spaces

LTRIM(RTRIM(ColumnName))

Example 2: sql trim all spaces

Select TRIM (' Word  ')