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.
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.