Specification of wildcards
You can use the % symbol as a wildcard in the specification of WHERE clauses. For example:
- FIND
- Application
- WHERE Application.Name LIKE ’A%’
finds all application with a name starting with 'A' or 'a'.
- FIND
- Application
- WHERE Application.Name LIKE ’%a%’
finds all application with a name containing an 'a' or 'A' at any position in the name.
Search is case insensitiv.