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.