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.
Solved! Go to 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*'
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*'
Ted:
You are right. The FC loaded is from a PGDB. Once I changed to FGDB, it works. Thanks.