how to remove space in sql table column value code example

Example 1: sql update table remove spaces

LTRIM(RTRIM(ColumnName))

Example 2: space not removing from column in sql

update thetable set thecolumn = rtrim(replace(thecolumn, char(160), char(32)))