QUERY TIP

 

WILDCARD CHARACTER

Criteria Tab

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.

Example:

Criteria:

Field: RECNAME

Operator: like

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.