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
>appology.
>
>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
statement...

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________