Rtrim

If Rtrim doesn't catch space at the end is there a way to catch strings that match but don't seem to get selected correctly when matching?Um, what do you mean by "Rtrim doesn't catch space at the end"? Or by "catch strings that match but don't seem to get selected correctly when matching"?|||Some sample data and some code would be helpfull.|||Is it possible there is some unwriteable chars there? Ie ASCII below 32?

I don't if the show up or not in SQL-Server, just related to C++ programming where unwriteable chars can mess up things.|||use this to check if the last char really is a space...

SELECT
ASCII(SUBSTRING(yourcolumnname, len(yourcolumnname), 1))
FROM yourtable