Wildcard Searches
See also: Beginning SQL
Wildcards use the LIKE keyword with a wildcard (%) because they are not exact matches.
Note: If you use equals (=) rather than LIKE, you only get exact matches. The system matches the percent symbol (%) rather than use it as a wildcard.
Contains
The Contains Wildcard search uses wildcards at the beginning and end. This example would return "Johnson, Kate" and "Smith, John."
Display_Name LIKE '%John%'Starts With and Ends With
Starts With uses a wildcard at the end. The name "Johnson, Kate" would be returned, but not "Smith, John"
Display_Name LIKE 'John%'
End With uses a wildcard at the beginning:
Display_Name LIKE '%John'It would return "Smith, John" but not "Smith, Johnny"
Like
Like allows you to enter your own wildcard combination. It is useful for more complex comparisons, such as:
Email_Address LIKE john%@%.com