how to remove space from column in sql code example

Example: space not removing from column in sql

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