>>> where a <> b or (a is null and b is not null) or (a is not null and >>> b is null) >> >> In the absence of IS DISTINCT FROM, I think this has the same semantics: >> >> where coalesce(a, b) <> coalesce(b, a) > > sorry, but no. So it would have to be where coalesce(a, b, 0) <> coalesce(b, a, 0) for your example with ints, and likewise some default value for other column types... -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice
