Query an Asterisk in the description

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Some of our product descriptions have an asterisk in the description to flag
those products. How do I query all the products that have an asterisk in the
description while using the asterisk as a wildcard?
 
Use a calculated field searching for the Ascii code 42 like this --
Expr1: InStr([YourField], Chr(42))

Use >0 as criteria.
 
Worked perfectly! Thank you!

Allen Browne said:
Enclose it in square brackets:
Like "*[*]*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Scott said:
Some of our product descriptions have an asterisk in the description to
flag
those products. How do I query all the products that have an asterisk in
the
description while using the asterisk as a wildcard?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter asterisks from a field 2
Filter also is a wildcard 4
Searching for asterisks within fields (not using as a wild card) 4
Search for Multiple * Literals 1
Asterisk is automatically added to the end of the query in SQL vie 2
Change query criteria by form with wildcards 6
Acknowledge an asterisk as a string 3
Asterisk next to a Sendkeys function in a macro 0

Back
Top