Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

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
0
jodstrr2
Asked:
jodstrr2
  • 3
1 Solution
 
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
 
mbizupCommented:
<< LIKE "##?09*" >>

Explaining:

that means "number, number, any character, 09, anything"
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now