On May 22, 2006, at 16:39, Adam wrote:

> Thanks for the reminder. I neglected to consider NULL. My only excuse
> is that in my requirement, I am dealing with a not NULL field. In any
> case, EXTRACT returns NULL if the field is NULL, so that logic is not
> required. NULL + 1 is also NULL.

Is this a change for FB2? TFB p160 warns about EXTRACT(NULL).
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com