Need help with SQL Select statement using LIKE

[jodyblau]

I'm not certain if it is possible to do this, and if it is I don't know
what the syntax would look like.

I am currently using a statement like so:

Set rs1 = CurrentDb.OpenRecordset("Select * from tblJudges WHERE Name
Like ""*" & myTerm & "*""", dbOpenDynaset)
What I would like to do is build this select statement such that it
selects records that are LIKE several different variables. Something
like: LIKE "a" OR LIKE "b" OR LIKE "c", so that it returns all records
that are like a,b and c.
Any help would be appreciated,

Thanks,

Jody Blau

[Br]

jodyblau wrote:

I'm not certain if it is possible to do this, and if it is I don't
know what the syntax would look like.

I am currently using a statement like so:

Set rs1 = CurrentDb.OpenRecordset("Select * from tblJudges WHERE Name
Like ""*" & myTerm & "*""", dbOpenDynaset)
What I would like to do is build this select statement such that it
selects records that are LIKE several different variables. Something
like: LIKE "a" OR LIKE "b" OR LIKE "c", so that it returns all
records that are like a,b and c.

Um, didn't you just answer your own question?

WHERE [Name] Like '*" & myTermA & "*' Or [Name] Like '*" & myTermB & "*'"
etc.

?
--
regards,

Br@dley

[jodyblau]

I suppose I did and just didn't realize it. I am fairly new at this
stuff.

I do, however, appreciate that you provided me with the proper syntax.

Thanks,

Jody

[Br]

jodyblau wrote:

I suppose I did and just didn't realize it. I am fairly new at this
stuff.

I do, however, appreciate that you provided me with the proper syntax.

Thanks,

Jody

No worries:)
--
regards,

Br@dley