Sample Header Ad - 728x90

Find and show special character codes from nvarchar column

1 vote
1 answer
4224 views
I want to know which special characters (line breaks, tabs, etc) are in my column of type nvarchar. I know how I can select which rows contain a specific character . e.g. 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.
Asked by Adam (245 rep)
Jun 18, 2022, 12:35 PM
Last activity: Jun 18, 2022, 01:16 PM