Query an Asterisk in the description

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?
 
K

KARL DEWEY

Use a calculated field searching for the Ascii code 42 like this --
Expr1: InStr([YourField], Chr(42))

Use >0 as criteria.
 
S

Scott

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

Please help me choose a product for the task 2
Filter asterisks from a field 2
Replace wildcards with a space 1
Filter also is a wildcard 4
Search for Multiple * Literals 1
If statements 3
Acknowledge an asterisk as a string 3
Searching for asterisks within fields (not using as a wild card) 4

Top