topic Wild card Query Not working in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478877#M18502 <HTML><HEAD></HEAD><BODY><P>The definition queries and the results are shown below</P><P>FACILITY_TYPE LIKE 'TCR'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - with records</P><P>FACILITY_TYPE LIKE '%TCR%'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - No record</P><P>FACILITY_TYPE LIKE 'TCR%'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - No record</P><P>What is wrong in the queries w/ wild card character?&nbsp; Thanks.</P></BODY></HTML> Wed, 28 Jun 2017 12:37:06 GMT ShaningYu 2017-06-28T12:37:06Z Wild card Query Not working https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478877#M18502 <HTML><HEAD></HEAD><BODY><P>The definition queries and the results are shown below</P><P>FACILITY_TYPE LIKE 'TCR'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - with records</P><P>FACILITY_TYPE LIKE '%TCR%'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - No record</P><P>FACILITY_TYPE LIKE 'TCR%'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - No record</P><P>What is wrong in the queries w/ wild card character?&nbsp; Thanks.</P></BODY></HTML> Wed, 28 Jun 2017 12:37:06 GMT https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478877#M18502 ShaningYu 2017-06-28T12:37:06Z Re: Wild card Query Not working https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478878#M18503 <HTML><HEAD></HEAD><BODY><P>What type of database are you using.... wildcards are depended upon the database. &nbsp;If you are using for example a personal geodatabase you would need to use a like '*TCR*'</P></BODY></HTML> Wed, 28 Jun 2017 14:35:55 GMT https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478878#M18503 TedKowal 2017-06-28T14:35:55Z Re: Wild card Query Not working https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478879#M18504 <HTML><HEAD></HEAD><BODY><P>Ted:</P><P>You are right.&nbsp; The FC loaded is from a PGDB.&nbsp; Once I changed to FGDB, it works.&nbsp; Thanks.</P></BODY></HTML> Wed, 28 Jun 2017 17:22:06 GMT https://community.esri.com/t5/arcgis-enterprise-questions/wild-card-query-not-working/m-p/478879#M18504 ShaningYu 2017-06-28T17:22:06Z