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.
tmajor99Asked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Maybe?:

name LIKE '%[^0-9]%'
0
 
Arifhusen AnsariBusiness Intelligence AnalystCommented:
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
0
All Courses

From novice to tech pro — start learning today.