RTRIM is not working as expected

Question

RTRIM is not working as expected

Viewing post 31 (of 30 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

Technically, I think that the fastest way to get rid of the unicode junk would be to cast it to VARCHAR. . . obviously this would remove any unicode data from the string that you might actually want.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/