AnsweredAssumed Answered

Wild card Query Not working

Question asked by shaningesri on Jun 28, 2017
Latest reply on Jun 28, 2017 by shaningesri

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.

Outcomes