Hi,

>I need to extract the year part of a date field in a IB table.

IB6: extract (year from datefield)

>Should I conclude that IB lacks a lot of handy functions that all other
>RDBMS have ?

Besides built in functions, IB has a standard UDF library, take the
Language Reference chapter 'User Defined Functions' for a more
information.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."