• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 432
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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