tmajor99
asked on
SQL Select - Finding chars in a column
I need to find column values that contain any letter or special character. Basically I want to do the same thing as this regular expression - [a-zA-Z-&$!@#$%^&*()_+=]* . So is there an easy to do this with a SQL Select. I do not want to have to specify a like for every value.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to use custom assembly for the same. It's like using CLR Code for the same.
Refer the below link you will get the clear idea.
http://www.codeproject.com/Articles/85954/Use-RegEx-in-SQL-with-CLR-Procs