Like in (doc*, pod*)

[hycho]

Hi,

I have a question regarding the like and in operators in MS Access. For example, on the criteria section of a query, I know the statement below works:

In ("John","Ray","Joe")

But I would like to know all names that are similar to John, Ray, Joe (and more). So I tried using the statement below in the criteria section:

Like in ("John*","Ray*","Joe*").

But the above like statement doesn't work, as in I get an error prompt that doesn't allow the query to execute. Does anyone know how I can resolve that issue?

Thanks.

 

[rzw0wr]

try Like "John" & "*"

Dale

 

[hycho]

Thanks for the suggestion. I thought of that scenario, and it would be cumbersome to keep typing the word "like", "and" for 100 names. See below for more details.

Like in ("John*","Ray*","Joe*", "*100 other names*")

Thanks again.