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

rgds

Si Carter
http://www.fbtalk.net/
http://sourceforge.net/projects/fbutils/
http://sourceforge.net/projects/dnfbb/