How to get a column that may contain special characters in sql server

Question

I have a situation where the name column contains many special characters. I have a solution in which I like, with all the special characters mentioned as '%[''",/# $!-@ %^&*.\+- ]% '' But this, I think, is not a good way to solve the problem: is there a way that I can use the regular expression in the SQL query itself to check if the column of the name contains special characters or not. All characters except alphabets and numbers would be special characters.

I know that Regex can be used with C # and T-SQL. Looking for something to do with native SQL

Answer 1

you can use

  WHERE yourcolumn LIKE '%[^0-9a-zA-Z]%' COLLATE Latin1_General_BIN 

Answer 2

http://msdn.microsoft.com/en-us/magazine/cc163473.aspx