sql server testing for 1 value in multiple columns : I have a table that has columns and I want to find out if all the columns contain that value. if they do not all contain that value I want to return the columns that do not contain it. can ANY or the IN clause be used for this? 

