>
> Thank you Sasha and Milan, I'm <deep breath> going to dive in and try
> doing this regex stuff all inside the stored proc, executing it with
> EXECUTE STATEMENT.
>
> I'll let you know how it goes..
>

Execute any search/replace with or without regex on your client side. I haven't a faintest clue how would I do any regex inside a stored procedure.
It's fairly easy to do it on the client using any language you use, c, c++, c#, delphi, php, whatever... (I'm not saying that I know any of these languages :))
It would be fairly complex and slow to do it on server.

Still, I don't understand why you need to use stored procedures at all?

Sasha