How do I query data using the Like operator, to search for a cert.

C

Christen

I need to use the Like operator to search through records, and return data in
the query that have the word "visual" in the title. How do i set this up?
 
D

Douglas J. Steele

In the criteria for your query, put

Like "*visual*"

If you're using ADO, the wildcard character will be %, not *, so you'll need

Like "%visual%"
 
C

Christen

how do i limit the criteria by using an OR, if i want titles that start with
an S or have the word visual in them?? im putting it like ="s" OR "*visual*",
but it wont return the titles that start with an S. The other one worked
like a charm!!
Thanks, Christen
 
Top