> HI All
>
> How can I get a row if a field is NULL in the following SELECT.
>
> select
> receivables.FIRST_NAME + ' ' + receivables.LAST_NAME as GUEST_NAME
> from
> receivables
> where
> last_name like 'SHIVAMB%'
>
>
> 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.
>
> Thanks
> Anton