I guess if I want to perform the query in one line (which I do), then
I have no choice but to call the UDF twice. Thanks guys for all your
suggestions!... It'll do for now, I can come back at a later date and
try to optimize things.

Matt.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 12:24 AM 12/03/2006, Si Carter wrote:
> >
> >
> > > -----Original Message-----
> > > ..but of course, firebird does not recognise 'result' as an actual
> > > column, so the query is illegal.
> >
> >It does recognise the column number so you could use
> >
> >SELECT F_MATCHCOUNT(concatenated_columns_string,
> >keywords) AS result, table_name.* FROM table_name WHERE result>0
ORDER BY 1
> >DESC;
>
> While it's true that it recognises the column number, it's not true
> that it avoids the repeat call to the UDF. It repeats it. It just
> saves typing.
>
> ./heLen
>