REGEX

Question

REGEX

steve.jacobs

SSCommitted

Points: 1830
More actions
November 13, 2013 at 10:21 pm

#279148

Comments posted to this topic are about the item REGEX
November 14, 2013 at 1:07 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bangla Hall of Fame Points: 3137 More actions · Answer 2

Bangla

Hall of Fame

Points: 3137

November 14, 2013 at 12:51 am

#1666277

Nice one....

Carlo Romagnano SSC-Insane Points: 22599 More actions · Answer 3

That's true:

In SQL Server, regular expressions really are poor.

😎

Mighty SSCrazy Eights Points: 9063 More actions · Answer 4

As far as I know SQL Server can only handle REGEX via the CLR, so .NET.

The queries as shown here were not using REGEX.

alex.d.garland Right there with Babe Points: 749 More actions · Answer 5

Mighty (11/14/2013)
As far as I know SQL Server can only handle REGEX via the CLR, so .NET.
The queries as shown here were not using REGEX.

+1

This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

alex.d.garland (11/14/2013)
Mighty (11/14/2013)
As far as I know SQL Server can only handle REGEX via the CLR, so .NET.
The queries as shown here were not using REGEX.
+1
This was a really good question to test understanding of SQL string pattern matching (thanks Steve!) but I don't believe it strictly counts as Regex.

Well, surely some of it is the nearest thing T-SQL has to REGEX? Maybe some of it really is too unlike REGEX to be thought of that way, but definitely some of it isn't.

Tom

Thomas Abraham SSChampion Points: 10761 More actions · Answer 7

Excellent question. Simply explained and good references. Thanks!

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

Stewart "Arturius" Campbell (11/14/2013)
Agree with the point regarding regex in T-SQL. .Net is definitely much more efficient in this regard...

+1 Thanks for the great question.

Everything is awesome!

Revenant SSC-Forever Points: 42467 More actions · Answer 9

Simple question but lots of mental work. Thanks, Steve!

webrunner SSC-Dedicated Points: 31718 More actions · Answer 10

Cool question, thanks.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 11

Mighty (11/14/2013)
As far as I know SQL Server can only handle REGEX via the CLR, so .NET.
The queries as shown here were not using REGEX.

What do you mean with that? As far as I understand, the examples did use regular expressions - a very limited form though.

Best Regards,

Chris Büttner

sqlnaive SSCoach Points: 17437 More actions · Answer 12

Good question Steve. It gave me little hard time. 🙂

jfgoude SSCrazy Points: 2586 More actions · Answer 13

good question !

eliminating possibilities one by one give a good guess

thanks