Identify Non Printable Special Characters


Identify Non Printable Special Characters



I have loads of tables and trying to find which of the field in a table have non printable special characters.

Is there any way to find the special characters with their type.


Table A  Table B  
Col 1Col 2 Col 3Col 4Col 5
A1 Xy44Old
B2  55New
C  Zs Old


I am trying to find a query which returns nothing for Col 1, extra space cell value for Col 2, extra space for Col 3 & 4 and nothing for Col 5.


Table NameCol NameValueSpecial Char Type
Table ACol 1 Space
Table BCol 3 Space
Table BCol 4 Space