February 15, 2002 at 2:57 pm
Does anyone know if (I would think yes) you can use regular expressions within a Stored Procedure. If so could you provide some sample code or a reference.
Thanks!
Neil
February 15, 2002 at 3:00 pm
You might take a look at patindex. The best implementation I've seen is in the VB Script regexp library, you'd have to use the sp_oacreate series of procs, not fun, but doable in a pinch.
Andy
February 15, 2002 at 3:11 pm
yeah I think I was looking for something simpler 🙂
Thanks,
Neil
p.s. I guess there isn't a regexp() function 🙂
February 15, 2002 at 3:45 pm
no reg expressions. I have a tamestrings series that looks at some tricks, but none are really a "grep".
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply