[AccessD] Why is using "=" faster than "LIKE" in Dlookup or elsewhere?

I was just dooing some stuff when I noticed this.
 
Using the = sign is much much faster in retrieving the ID than using
LIKE in the line below.
 using "=" is instantly, using "LIKE" is something between half a second
and a second.
 
DLookup("HTML_LID", "HTML_PageTable",
"[ReceiveDateAndFileInArchiveDir]=" & Chr(34) & oItem.ReceivedTime &
Chr(8) & oItem.EntryID & Chr(34))
 
 
Correct me if I'm wrong but is the reason that "=" uses a bitcompare and
"LIKE" a databasecompare?
 
meaning
using "="
"a" <> "A"
 
using "LIKE"
"a" = "A"
 
 
 
 
 
 
 

Erwin Craps

Zaakvoerder 

www.ithelps.be/jonathan

 

This E-mail is confidential, may be legally privileged, and is for the
intended recipient only. Access, disclosure, copying, distribution, or
reliance on any of it by anyone else is prohibited and may be a criminal
offence. Please delete if obtained in error and E-mail confirmation to
the sender.

IT Helps - I.T. Help Center  ***  Box Office Belgium & Luxembourg

www.ithelps.be <http://www.ithelps.be/>   *  www.boxoffice.be
<http://www.boxoffice.be/>   *  www.stadleuven.be
<http://www.stadleuven.be/> 

IT Helps bvba* ** Mercatorpad 3 **  3000 Leuven

IT Helps  *  Phone: +32 16 296 404  *  Fax: +32 16 296 405 E-mail:
Info at ithelps.be 

Box Office **  Fax: +32 16 296 406 **  Box Office E-mail:
Staff at boxoffice.be <mailto:figures at boxoffice.be>