Link to home
Start Free TrialLog in
Avatar of tmajor99
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
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
There is noway you can have the search by regular expression in sql server.

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