Replacement strings for Lookup queries
This table shows the replacement strings that are used for lookup queries.
| Token | Description |
|---|---|
[%%ESCAPECHAR] |
The default value is a backslash. |
[%%LIKECLAUSE] |
This token is replaced with a starting value. |
Example
An example of a query that uses [%%LIKECLAUSE] is ACTIONLOOK2. The Query Text is:
SELECT DESCRIPTION, ACTION_CODE
FROM FSACTION WHERE LOGICAL_DELETE = 0 AND DESCRIPTION LIKE [%%LIKECLAUSE]
ORDER BY DESCRIPTION