Scott Duncan-251680 (1/7/2010)

---

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.