Re: [firebird-support] Best Practice re null

[Stefan Heymann]

> In certain queries I wish nulls to be treated as empty strings. For example:
>   Select Field1 || ' ' || Field2 AS MyOutputValue;

Try this:

select coalesce (Field1, '') || ' ' || coalesce (Field2, '') AS MyOutputValue;


HTH

Regards

Stefan