Yes, I was convinced, until special case query(where I got a bit confused (-
that '= null' does not exists at all.
But see this dilema:
I would say here in condition :
select * from tab2 where varcharfield = null
and in this case:
select * from tab1 left join tab2 on tab1.id = tab2.id were tab1.id is null
coz, in first case null is actualy there, in table, in second it is not, it is produced by query.
Do you mean 'is null' should work in any upper case & in any case at all ?