Re: Conjunction junction

"Alan" <alan_at_erols.com> wrote in message news:2un1tqF2bo5daU1_at_uni-berlin.de...

> The worst part is, we don't even have an XOR in SQL.

Most of the time, you can get away with "not equal to" instead of XOR. This is usually written "<>", but can be written as "=!" in some dialects, IIRC. So

select * from blocks
where
(color = 'RED') <> (shape = 'SQUARE')

It's ugly, but it's better than nothing. Received on Mon Nov 01 2004 - 11:14:27 CST