When the value specified for your WHERE clause contains special characters, the results might not be as expected because the characters are treated as operators rather than characters in a string. For example, the symbol % is used as a wildcard in the Alfabet query language. Therefore, the WHERE clause
- WHERE ObjectClassName.PropertyName LIKE ’10%’
will not limit search results to all values that equal '10%' but all values containing '10' followed by any characters.
You cannot search for the following special characters in Alfabet queries:
- %
- _
- *