| Subject | Re: [firebird-support] SELECT returns nothing if one field is NULL |
|---|---|
| Author | Dmitry Sibiryakov |
| Post date | 2005-08-12T06:59:14Z |
On 12 Aug 2005 at 5:56, rekkod wrote:
--
SY, Dimitry Sibiryakov.
>If FIRST_NAME or LAST_NAME is NULL nothing gets returned. Is there aRTFM Release Notes about COALESCE().
>way of specifying that if FIRST_NAME is NULL to return an empty string
>in one SELECT and concatenating the fields.
--
SY, Dimitry Sibiryakov.