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
Last activity: Jun 18, 2022, 01:16 PM