On Mon, 2009-12-07 at 12:26 +0000, Ford, Mike wrote: > This is pretty much why SQL does not offer you the XOR operator! Someone better tell the MySQL developers then... http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html Thanks, Ash http://www.ashleysheridan.co.uk