"Daniel Rail" <drail@...> wrote in message
news:5.1.0.14.2.20020204165916.040d3cd8@......

>
> Look into the Interbase 6 beta documentation volume Language
> Reference(pages 183-187). You'll find most of the reserved words for
> Firebird and Interbase. For Firebird, the only other words not listed in
> the document would be FIRST and REPLACE.

FIRST, SKIP, RECREATE (not REPLACE), CURRENT_USER, CURRENT_ROLE, BREAK (not
functional, but it exists), SUBSTRING and DESCRIPTOR.

Treat COALESCE, NULLIF, CASE, ABS, IIF, TRIM, CHAR_LENGTH, CHARACTER_LENGTH
and OCTET_LENGTH as if they were reserved. They will probably become
reserved words in the future. They are tokens in the SQL standard, with the
exception of IIF. In addition, TRIM in turn calls for LEADING, TRAILING and
BOTH.

Furthermore, treat the new IB6.5 keywords as reserved for compatibility:
ROWS, TIES, PERCENT.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing