See invisible control character in varchar field
Posted on 2006-10-30
Every once in awhile someone seems to enter an invisible control character in a varchar field through my application. When the dataset containing this record is selected and loaded into another application, problems occur. I never know what the actual character is, but the len() function reveals more characters than I can acutally see. It would be nice if I could see these invisilbe control characters by running a select statement in SQL Query Analyzer.
QUESTION: When running a select statement in Query Analyzer against a varchar or char field, is there a way to also see the invisible characters, e.g. control characters, carriage returns, new line, etc.