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.
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.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
