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

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

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

SELECT   FROM tableName WHERE columnName LIKE       OR columnName LIKE       OR  etc

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

Examples related to sql

Examples related to sql-server