sql server remove spaces left right code example Example 1: sql update table remove spaces LTRIM(RTRIM(ColumnName)) Example 2: sql trim all spaces Select TRIM (' Word ')