Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to find special characters in SQL field?

Question
James Woo · Jan 17, 2020

How to find special characters in SQL field?

I like to use something like this:

select * from MyTable where MyFieldName like ‘%[^a-zA-Z0-9 !”%#$&”()*+,-./:;<=>?@]%’  

to find field that contains special characters that are only allowed.

#SQL #Caché

Source URL:https://community.intersystems.com/post/how-find-special-characters-sql-field