Subject Re: [firebird-support] Null values in field
Author Helen Borrie
At 09:16 AM 18/12/2003 +0200, you wrote:
>Hi all
>Can anyone please tell me what the FireBird equivalent is for Oracle's
>nvl(), where I want to select on a specific field including those with NULL
>in them

COALESCE(YourColumn, value)

If not using Firebird 1.5, you'll need to use one of the *NVL external
functions in fbudf.