In SQL Is IN' an operator or function?

Question

In some sites  I found .. SQL IN is an operator whereas in a few sites it is mentioned as a function. I got bit confused?

Akkiraju Ivaturi · Answer

Hi Hemant IN is not a function it is an operator. It is always good to refer the help articles from the sites of the companies who have defined or part of setting standards for SQL. Please have a look at the following URL from Microsoft: http://msdn.microsoft.com/en-us/library/ms189773 Operator Meaning ALL TRUE if all of a set of comparisons are TRUE. AND TRUE if both Boolean expressions are TRUE. ANY TRUE if any one of a set of comparisons are TRUE. BETWEEN TRUE if the operand is within a range. EXISTS TRUE if a subquery contains any rows. IN TRUE if the operand is equal to one of a list of expressions. LIKE TRUE if the operand matches a pattern. NOT Reverses the value of any other Boolean operator. OR TRUE if either Boolean expression is TRUE. SOME TRUE if some of a set of comparisons are TRUE.

Akkiraju Ivaturi · Answer

Hey Hemant mark it as accepted if you are satisfied with the answer.

Hemant Srivastava · Answer

Thanks.. actually i got confused with this link: http://www.techonthenet.com/sql/in.php

In SQL, Is "IN' an operator or function?