17Jul07 Remove a dash in multiple records with TSQL
Just a self-reference to TSQL code used to clean up multiple records in a table column by removing a dash from the value.
SELECT TOP 10 * FROM table_name WHERE some_logic
SELECT replace(column_name, '-', '') as [New column_name] FROM table_name WHERE some_logic
UPDATE table_name SET column_name = replace(column_name, ‘-’, ”) WHERE some_logic