Replace tab in MS SQL

Replacing a tab with something else in MS SQL is easy peasy, following is the code

update [table name]
set [column name] = REPLACE( [column name], CHAR(9), ' ')