Subject Re: [ib-support] pb with fbuf function snullif and left join query
Author Helen Borrie
At 12:16 PM 06-06-02 +0200, you wrote:
>Hello, I'm not sure if it's the right place to post this pb if not I
>I try to use snullif function or snvl in a left outer join query and doesn't
>get the expected result.
>When I filter the null column the snullif function returns null.
>select a.a, snull(b.b , 'somestring')
>from a left outer join b
>where b is null

Show us the actual statement, since this example is not a valid SQL


All for Open and Open for All
Firebird Open SQL Database · ·