Wild card Query Not working

517
2
Jump to solution
06-28-2017 05:37 AM
ShaningYu
Frequent Contributor

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.

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
TedKowal
Regular Contributor II

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*'

View solution in original post

2 Replies
TedKowal
Regular Contributor II

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
Frequent Contributor

Ted:

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

0 Kudos