Hi... I'm trying to clean up some data in my table, and am finding that my script to remove duplicates isn't working right. It looks to me that there are spaces at the end of each string in one of my columns, which I'm not able to remove. I've tried using rtrim and replace, but to no avail. For example:
SELECT REPLACE(SUID,' ',''), "SUID" FROM news_Indexing.dbo.gsstatus;
where the column SUID displays 31 characters instead of the 12 which are visible alpha numerics.
The other odd thing is, the first row in the 169,000 table does NOT have the spaces at the end of each string.
Can somebody please advise?
Thank you for any help!