Wild card Query Not working

[ShaningYu]

The definition queries and the results are shown below

FACILITY_TYPE LIKE 'TCR'                         - with records

FACILITY_TYPE LIKE '%TCR%'                   - No record

FACILITY_TYPE LIKE 'TCR%'                      - No record

What is wrong in the queries w/ wild card character?  Thanks.

[TedKowal · Accepted solution]

What type of database are you using.... wildcards are depended upon the database.  If you are using for example a personal geodatabase you would need to use a like '*TCR*'

[ShaningYu]

Ted:

You are right.  The FC loaded is from a PGDB.  Once I changed to FGDB, it works.  Thanks.