On 2-1-2018 19:52, 'Walter R. Ojeda Valiente' [email protected] [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
