RE: Difference between = and IN

From: Ram Kumar Koditala (RamKumarKoditala_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 14:31:02 -0800

If I am not wrong,
Index will be used which are part of =, if any exist
Thanks,
RK

"Andy" wrote:

> Hi
> Does anybody know what the difference is between the 'IN' and '=' operators.
> I am aware that '=' compares two expressions whereas 'IN' looks to see if an
> expression appears in a list and that a statement including an '=' operator
> is quicker to type than one with an 'IN'. Other than that I can't see that
> '=' does anything that 'IN' can't do. Is there an overhead associated with
> using the 'IN' operator?
> Thanks in advance...