Operator: select Like from drop down box
Double-click expression 2
Input desired criteria with wildcard character: %
Example: A% finds any string beginning with the letter A.
Expression 2: %FIELD%
Will result in records (tables) with "FIELD" found anywhere in the record name.
Wildcard characters available depend on the system we are using:
% percent sign - match one or more characters
_ underscore – match any single character
\ backslash – don’t treat the next character as a wildcard
If the name of a panel, record, or field contains a wildcard character such as underscore, you can negate the wildcard by placing a backslash immediately in front of the wildcard character.
Example: PS Panel Name LIKE AP\_% will result in all panels starting with "AP_"
Caution:Use of operator "LIKE" may slow Query response time significantly. This may become critical when we move into production.