How to detect if a string contains special characters

Question

How to detect if a string contains special characters like        amp        etc  non-alphanumeric characters  in SQL server 2005

User · Answer

SELECT   FROM tableName WHERE columnName LIKE       OR columnName LIKE       OR  etc

User · Answer

Assuming SQL Server   e g  if you class special characters as anything NOT alphanumeric   DECLARE  MyString VARCHAR 100  SET  MyString    adgkjb    IF   MyString LIKE     a-zA-Z0-9         PRINT  Contains  special  characters  ELSE     PRINT  Does not contain  special  characters    Just add to other characters you don t class as special  inside the square brackets

User · Answer

In postgresql you can use regular expressions in WHERE clause  Check http   www postgresql org docs 8 4 static functions-matching html  MySQL has something simmilar  http   dev mysql com doc refman 5 5 en regexp html

[sql] How to detect if a string contains special characters?

Examples related to sql

Examples related to sql-server