Filter asterisks from a field

  • Thread starter Thread starter Dimitris
  • Start date Start date
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
 
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 "*[*]*"
 
Back
Top