Validate table data with regex in SQL server

Question

I have a MSSQL table with large number of alpha numeric codes. I have to verify these codes are within certain characters. How do I write a SQL in MSSQL? Any advice ?

Codes Table

JFBBB22 -> Valid

JBBYB33 

AXBBB22 ->Invalid

LBBBB33

Code I am using in c# to validate..

Regex.IsMatch(code, "^[BCDFGHJKLMNPQRSTVWXZ123456789]*$").

GriGrim · Accepted Answer · 2013-09-25 19:18:15Z

1

WHERE code NOT LIKE '%[^BCDFGHJKLMNPQRSTVWXZ123456789]%'

answered Sep 25, 2013 at 19:18

GriGrim

2,9411 gold badge25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Web crawler Over a year ago

Perfect..That's what I wanted.. I was struggling with regex in select.

George · Accepted Answer · 2013-09-25 19:16:27Z

0

You can do it like this:

select dbo.RegexMatch( N'123-45-6789', N'^\d{3}-\d{2}-\d{4}$' )

For the full documentation check The MSDN site for the official page

answered Sep 25, 2013 at 19:16

George

6286 silver badges13 bronze badges

Collectives™ on Stack Overflow

Validate table data with regex in SQL server

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related