> 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.
