On 2-1-2018 19:52, 'Walter R. Ojeda Valiente'
sistemas2000profesional@... [firebird-support] wrote:

>
>
> What about:
>
> SELECT
>    A,
>    B,
>    COALESCE(C, 'some value here')
> FROM
>    MyTable

That still requires column C to exist. Coalesce is for replacing null
values with an alternative value.

Mark
--
Mark Rotteveel