Simple way to search for all special characters in all fields?

Rafferty Uy

Hi, I want to find out if there are special characters in the text fields values of my database. Is there a simple way to do this? My current thoughts is using the complicated way of

SELECT * FROM MyTable
WHERE Col_Name LIKE '%~%' OR Col_Description LIKE '%~%'
OR Col_Name LIKE '%`%' OR Col_Description LIKE '%`%'
OR Col_Name LIKE '%!%' OR Col_Description LIKE '%!%'
OR Col_Name LIKE '%@%' OR Col_Description LIKE '%@%'
...

SELECT * FROM MyOtherTable
WHERE OtherCol_Name LIKE '%~%' OR OtherCol_Description LIKE '%~%'
OR OtherCol_Name LIKE '%`%' OR OtherCol_Description LIKE '%`%'
OR OtherCol_Name LIKE '%!%' OR OtherCol_Description LIKE '%!%'
OR OtherCol_Name LIKE '%@%' OR OtherCol_Description LIKE '%@%'
...

But maybe there's an easier way? Thank you in advance.

Rafferty

Rafferty Uy

By special characters, I meant all characters that are not alpha-numeric. Thank you again.

Rafferty

ed5756

What you want to use is regular expressions. Plenty of examples on google, e.g. http://www.sqlteam.com/article/regular-expressions-in-t-sql[^]