> I believe that would encourage to treat NULL as a value instead of a
> state.
> If one has to test for null as a value, then maybe his database design
> has a flaw.
> Starting to change the SQL text by changing parameter values could be a
> dangerous trend, in my view. Would you also change 'WHERE ACOL <> :A'
> into 'WHERE ACOL IS NOT NULL'? What about 'WHERE ACOL >= :A'?

I agree that this is opening a can of worms and I have as yet never needed
this in my own applications. I feel like it probably is a design flaw if
this is needed.

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com