> That is fine
> but what I was actually expecting is this
> if
> select * from table where col_name in (null, 'a', 'b');
>
> to return those rows where col_name is null or if it = a or if it is = b
>
> But i think in does not not support null queries , am i right?
>
that is correct: if col_name was actually 'a' then you would get:
'a' in ( null, 'a', 'b', ...) works the same as:
'a' = null ~ resolves to Unknown
or
'a' = 'a' ~ resovles to true
or
'a' = 'b' ~ resovles to false
or
...
so you end up with:
(unknown or true or false) = true
but if you have
(unknown or false or false) = false
Regards,
Richard Broersma Jr.