Regular expression in MS SQL?

String manip is limited in mssql-- any ideas for implementing an ActiveXObj

[broniusm]

Anyone have any luck overcoming MSSQL's limited string manip functions by calling on help from an ActiveXObject or plugin user function of some sort?

(rephrased: "How can I get some regexp string manip in a stored procedure in MSSQL 2000?")

[broniusm]

So far, I'm chasing this goose:

exec @resultcode = master.dbo.sp_OACreate 'VBScript.RegExp', @oRegExp OUT

I'll keep me posted...

[webdevsf]

I was wishing for the same thing... But that's going to be slow...