| Subject | Re: [firebird-support] Change null values of a select results to a non-breaking space |
|---|---|
| Author | Gordon Niessen |
| Post date | 2011-05-28T02:37:47Z |
SELECT
USERS.ID, COALESCE(CT_TITLES.DESCRIPTION||' ', '')||USERS.FULL_NAME AS
FULLNAME
FROM USERS
LEFT OUTER JOIN CT_TITLES ON (CT_TITLES.ID = USERS.CT_TITLES_ID)
USERS.ID, COALESCE(CT_TITLES.DESCRIPTION||' ', '')||USERS.FULL_NAME AS
FULLNAME
FROM USERS
LEFT OUTER JOIN CT_TITLES ON (CT_TITLES.ID = USERS.CT_TITLES_ID)
On 5/26/2011 11:05 AM, nols_smit wrote:
> SELECT
> USERS.ID, COALESCE(CT_TITLES.DESCRIPTION, USERS.CT_TITLES_ID) AS
> TITLE, USERS.FULL_NAME AS NAME
> FROM CT_TITLES
> RIGHT OUTER JOIN USERS ON (CT_TITLES.ID = USERS.CT_TITLES_ID)
--
Thanks,
Gordon