--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <roman@...> wrote:

> Yup. Therefore try instead "x=?" another form, which is "x IS NOT
> DISTINCT FROM ?". This is longer to write, but does exactly what you
> need. Works however only in 2.0+.

i can't...i have to deal with 1.5.
in the end i wrote an handler for this special case and use it only
when strictly needed.

> Issue is that NULL=NULL -> false and this is according to the SQL

standard.

y, i always forgot about that...it sounds like a bad choice... at
least based on my experience...