Solved

SQL Select - Finding chars in a column

Posted on 2016-09-22
2
47 Views
Last Modified: 2016-09-27
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.
0
Comment
Question by:tmajor99
2 Comments
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
Comment Utility
Maybe?:

name LIKE '%[^0-9]%'
0
 
LVL 12

Expert Comment

by:Arifhusen Ansari
Comment Utility
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

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now