> -----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