Solved

Wild Card question

Posted on 2011-09-16
5
424 Views
Last Modified: 2012-05-12
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
Comment
Question by:jodstrr2
  • 3
5 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 36550362
Assuming an Access Back End you would use this criteria:

LIKE "##?09*"
0
 
LVL 82

Expert Comment

by:hielo
ID: 36550363
>>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
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 36550373
<< LIKE "##?09*" >>

Explaining:

that means "number, number, any character, 09, anything"
0
 

Author Closing Comment

by:jodstrr2
ID: 36550408
Thank you!!! That's what I was looking for.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 36550437
Glad to help :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to set Excel's default SaveAs folder, from Access VBA 6 42
Send Meeting Request from Shared Mailbox 3 58
Dinamic report to Crosstab query 9 33
Sum in Split Form 17 27
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question