Edit: the solution provided by vax was successful, and should work for just about anyone facing a similar issue, as it replaces 4 different types of spacing, not just spaces. Thanks to all who provided help!
I have a table that gives industry names, but for one of the columns the distinct values have duplicates.
Here is the query I have:
select distinct replace(final_industry,' ','') from industryNorm
If you believe the problem is due to other white spaces I had a similar question that someone answered
select distinct replace(replace(replace(replace( final_industry ,char(9)/*tab*/,'') ,char(10)/*newline*/,'') ,char(13)/*carriage return*/,'') ,char(32)/*space*/,'') from industryNorm