<div>
Assuming an Access Back End you would use this criteria:<br />
<br />
LIKE &quot;##?09*&quot;
</div>


Assuming an Access Back End you would use this criteria:

LIKE "##?09*"

<div>
&gt;&gt;I tried to use like*09 <br />
put the value in apostrophes:<br />
I tried to use like '*09'<br />
<br />
That will give you the records where the field END with 09. If you want a &quot;contains&quot;, put the wild-card both to the left an right of 09:<br />
... LIKE '*09*'<br />
<br />
Finally, if that still does not work try:<br />
... LIKE '%09%'<br />

</div>


>>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%'


<div>
Thank you!!! That's what I was looking for.
</div>


Thank you!!! That's what I was looking for.

<div>
<div class="content wysiwyg-content">
Hi Expert,<br />
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. &nbsp;I tried to use like*09 but it doesn't work.<br />
<br />
Thanks
</div>
</div>


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

Wild Card question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.