combining Multiple Likes

[newfrontiers]

I have been searching Tek-Tips for an answer to this but I am probably entering the wrong key words. Any help is appreciated.

I have a query that requires numerous Like criteria. Basically, it takes a listing of numbers (can be as many as 50) and then queries. Do I need to do this through Like "123*" OR like "456*"...? Or is there a command such as in list ("123*","456*")?

Because there are three other pieces of criteria you can imagine how unwieldy the query gets by using the OR.

Thanks for your help.

 

[SkipVought]

Hi,

Since they are ALL 3 bytes, hou 'bout this?...

Where Left([TheField], 3) IN ('123,'456','789',....)

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[newfrontiers]

Thanks! I will give it a try.