TSQL string regex matching

Question

Is it possible to check if a string variable matches a regex in SQL Server? I want something simple like @stringVariable = @regex and get as result something like true/false.

Microsoft SQL Server 2012

Jelly
– Jelly

2014-01-06 11:27:39 +00:00
Commented Jan 6, 2014 at 11:27 — Jelly
– Jelly, Commented Jan 6, 2014 at 11:27

XN16 · Accepted Answer · 2014-01-06 11:28:36Z

3

Assuming you mean Microsoft SQL Sever, then you can't as it doesn't support regex out of the box.

However you could shell out the process to a CLR Stored procedure, or if it is a very simple regex, you might be able to use a LIKE keyword.

Here is a link about CLR regex support. I used this myself a few years ago until I abandoned the idea of using regex in my case!

answered Jan 6, 2014 at 11:28

XN16

5,88916 gold badges52 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

TSQL string regex matching

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related