I want to know which special characters (line breaks, tabs, etc) are in my column of type
I know how I can select which rows contain a specific character.
SELECT * FROM your_table WHERE your_column LIKE '%' + CHAR(10) + '%'
However, I want to know which columns contain characters not in
[a-zA-Z0-9] and then WHICH characters that are.
I also looked if I can just do a select on a column to display RAW text with all characters displayed (similar to Microsoft Word's display all characters for example), but I couldn't find how to do this either.