|Subject||RE: [firebird-support] Re: Possible to write this in a way that indices will be used|
>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.
> 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..
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?