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. |
For Oracle databases, additional rules apply to the [%%LIKECLAUSE] token. You must specify LINGUISTIC for NLS_COMP. You must specify
BINARY_AI or BINARY_CI
for NLS_SORT.
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