Wild Card question

Hi Expert,
How do I enter a wild card in a query that pull every record the match 09, for example, I have 85S09123, 97D092345 etc, I want to pull all record that are the fourtht numer start as 09.  I tried to use like*09 but it doesn't work.

Thanks
jodstrr2Asked:
Who is Participating?
 
mbizupCommented:
<< LIKE "##?09*" >>

Explaining:

that means "number, number, any character, 09, anything"
0
 
mbizupCommented:
Assuming an Access Back End you would use this criteria:

LIKE "##?09*"
0
 
hieloCommented:
>>I tried to use like*09
put the value in apostrophes:
I tried to use like '*09'

That will give you the records where the field END with 09. If you want a "contains", put the wild-card both to the left an right of 09:
... LIKE '*09*'

Finally, if that still does not work try:
... LIKE '%09%'
0
 
jodstrr2Author Commented:
Thank you!!! That's what I was looking for.
0
 
mbizupCommented:
Glad to help :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.