Difference between = and IN

From: Andy (Andy_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 03:39:07 -0800

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...

Relevant Pages

  • Re: Function Vs Expressions
    ... expressions, they should be faster because is aggregated in access. ... There is overhead associated with the use of a domain aggregate function. ... every row or loop iteration and then it becomes a significant performance ...
    (microsoft.public.access.formscoding)
  • Re: Everything in ruby is an object?
    ... Jano Svitok wrote: ... expression from the db and I was just wondering if there was a quicker ... No. Expressions are not objects. ...
    (comp.lang.ruby)