How to filter a table with...??

  • Thread starter Thread starter Mirko
  • Start date Start date
M

Mirko

Hi all!
My question is how to filter a access column with the
next task: I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix. Also the criteria is that field contains
*. The fields are diferent and have diferent strings like
+, -, etc.
TIA Mirko
 
Hi all!
My question is how to filter a access column with the
next task: I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix. Also the criteria is that field contains
*. The fields are diferent and have diferent strings like
+, -, etc.
TIA Mirko
Click to expand...

This is a bit tricky because the LIKE operator - which lets you search
using wildcards, partial strings, etc. - uses * as a wildcard meaning
"match any string".

The solution is to use [] to indicate to Access that you are searching
for a literal asterisk: a query criterion of

LIKE "*[*]*"

will find records containing any number of characters (the first *), a
literal asterisk, and then any number of trailing characters.
 
I want to have listed all fields from a column
that have in their fields (The field is a text field)
a "*" asterix.
Click to expand...

In addition to John's solution, the other one is

WHERE INSTR(MyTextField, "*")>0

Hope that helps


Tim F
 
Back
Top