Subject Re: [firebird-support] SELECT returns nothing if one field is NULL
Author Dmitry Sibiryakov
On 12 Aug 2005 at 5:56, rekkod wrote:

>If FIRST_NAME or LAST_NAME is NULL nothing gets returned. Is there a
>way of specifying that if FIRST_NAME is NULL to return an empty string
>in one SELECT and concatenating the fields.

RTFM Release Notes about COALESCE().

SY, Dimitry Sibiryakov.