SQL Server statement to remove all spaces in a column.

-- Updates the target "column_name" with *all* spaces removed
-- (including leading and trailing spaces):
update table_name
set column_name = replace(column_name, ' ', '');