Thanks for the suggestion. I considered that approach, but the problem
is that the queries are generated dynamically, so I would have to
create a view dynamically, perform the query, and then destroy the
view, which is not really practical.


--- In firebird-support@yahoogroups.com, "Si Carter"
<simon.carter@...> wrote:

>
>
>
> > -----Original Message-----
> > I have written a UDF ( F_MATCHCOUNT(string, pattern) ) that
> > returns the number of times a given pattern string occurs in
> > another string.
> > Is there a more efficient way I can perform the following
> > query on Firebird 1.5, where I only need to call the UDF once?
>
> You could always create a view and then perform a select on the view

with an

> order by where matchcount > 0
> Rgds
>
> Si Carter
> http://www.fbtalk.net/ - Web Based Firebird Forum
> http://sourceforge.net/projects/fbutils - FBUtils
> http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered

Forum

>