Filter asterisks from a field

D

Dimitris

Hello, I have a field in a table in which there are asterisks (*) entered in
some data. How can I filter those records in which asterisks are entered?
For example there might be an entry (John*Smith) I need to find all these
entries with asterisks.

Can someone help me?

Thank you
Dimitris
 
K

Krzysztof Naworyta

Dimitris wrote:
| Hello, I have a field in a table in which there are asterisks (*)
| entered in some data. How can I filter those records in which
| asterisks are entered? For example there might be an entry
| (John*Smith) I need to find all these entries with asterisks.
|
| Can someone help me?

(...)
WHERE Field1 Like "*[*]*"
 

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

Delete all data after a symbol in a field 0
Is this possible? 0
Dealing with the error: unable to filter on excel hc home school 0
Can you delete all asterisks in a sheet? 7
Specific filter for the data in a field 1
Cutting copy to the clipboard with wildcards 0
Strip leading characters from field name 16
Prevent line of asterisks from turning into a bullet line? 4

Top