Hi,

>>IB6: extract (year from datefield)
>
>IT WORKS!
>
>I cannot find but doc re to v. 5.x , where 'extract' is taken as a keyword
>but is undefined.
>
>How did you find the existance and the correct syntax for the function

above ?

>

I think there was a part of this in the release notes for IB6 or the
migration guide or something.

And for the final (certified) version of IB6 and IB6.5, there's a page in
the Language Reference, page 119, that explains it in detail.

>>Besides built in functions, IB has a standard UDF library
>
>I have gone thru it, but it contains only a couple of functions that
>nterest me

Well, that's ok then. There are also several free UDF libraries available
with tons of neat functions...

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."