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