Is there a more concise way of expressing the following select:- SELECT * FROM maintable where Owner = 2 or Contact = 2 or AccountsContact = 2 or Owner = 3 or Contact = 3 or AccountsContact = 3 or Owner = 4 or Contact = 4 or AccountsContact = 4 ORDER BY DomainName ASC;
Charlie