>SQL select help says "The Where clause supports the ESCAPE operator for the JoinCondition, allowing you to perform meaningful queries on data containing the SELECT - SQL % and _ wildcard characters."
>
>Has anyone used this or got it to work, and if so, can you provide proper syntax? Since help doesn't mention what the 'Escape operator' is, I tried the literal WHERE ESCAPE '%' but I failed to perform any 'meaningful queries';)
From the SELECT - SQL help:
Example 9Example 9 displays FilterCondition in the form of FieldName [NOT] LIKE cExpression
customer.country NOT LIKE "UK"
>/pr>
This filter condition searches for each field that matches cExpression.
You can use the percent sign (%) and underscore ( _ ) wildcards as part of cExpression. The percent sign represents any sequence of unknown characters in the string. An underscore represents a single unknown character in the string.