Handling of special characters

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:

• %
• _
• *