Filtering for fields with character

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

How can I filter for results that contain the charcter "(" ?

For example if my fields are:

A(2001)
B(2004)
C
D(2055)
E(2006)

I would like to display results that contain parentheses brackets.

I try filtering using the wildcard *(* but it does not work.
 
How can I filter for results that contain the charcter "(" ?

For example if my fields are:

A(2001)
B(2004)
C
D(2055)
E(2006)

I would like to display results that contain parentheses brackets.

I try filtering using the wildcard *(* but it does not work.
Click to expand...

Try

LIKE "*(*"

Wildcards only work with the LIKE operator; if you just put

*(*

on the criteria line it will search for that exact sequence of three
characters.

If you want to search *for a wildcard character* without having it treated as
a wildcard, enclose it in square brackets:

LIKE "*[#]*"

will search for the # character, rather than treating it as a numeric digit
wildcard.
 
Back
Top