Jeff Cook-476310 (1/7/2010)
I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/and answered predicate (to the revised question), the site said:
Sorry - you were wrong
Correct answer: Operator
Explanation: In T-SQL, a PREDICATE allows you to check whether a value or scalar expression evaluates to TRUE, FALSE, or UNKNOWN. The IN clause, with column and values becomes a predicate and checks to see if at least one of the elements in a set is equal to a given value or expression.
T-SQL PREDICATE: http://msdn.microsoft.com/en-us/library/ms189523%28SQL.90%29.aspx
Join the discussion about this question
Contribute a question of your own
Ditto - I chose predicate. Even more confusing when I was reading through the comments (thinking "but IN isn't by itself - the whole statement will resolve to TRUE, FALSE or UNKNOWN") until I got to this post and realised the question had been altered - although not the answer it would appear.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare