I'm trying to manually test to see if part of my WHERE clause will work correctly:
... and (ColA=1 or ColB is null) ...
and it's likely that ColA will
Question: HOW can I test this MANUALLY "at the console" with a simple select statement?
I tried something like this and doesn't work... it returns a syntax error:
select null or 1
to illustrate ColA being null and ColB NOT being null. I want to "prove" this will evaluate TRUE (null or TRUE => TRUE).