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

snull(b.b , 'somestring') returns null where as it should returns
'something' for null column.

Apart, the function works fine on a single table.

Is it a problem with firebird engine or fbuf library ?

In ORACLE the behavior is as expected.

Any Idea, or does someone knows where I can post UDF pbs ?

Olivier STEINBERG










[Non-text portions of this message have been removed]