MS SQL Statement Result contains line breaks or white spaces :: How to TRIM ALL & ANY White Spaces???
Posted on 2007-11-29
I have a problem, my SQL 2005 db tables contains fields which in return contain whitespaces (hidden characters like #13#10, line breaks etc....) and this results in headaches when you want to do standard select query with where clauses etc because the data never matches.
How can I select fields and trim or remove all whitespaces of any nature?
A normal RTRIM() and LTRIM() does not seem to remove all.
Advise me please...