Solved

SQL Select - Finding chars in a column

Posted on 2016-09-22
2
61 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:
Scott Pletcher earned 500 total points
ID: 41811342
Maybe?:

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

Expert Comment

by:Arifhusen Ansari
ID: 41812192
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

778 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