Wildcard Searches in SQL
This section discusses using wildcard searches in your SQL comparisons in the Platform, including CONTAINS, STARTS WITH, ENDS WITH, and LIKE.
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 uses 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."
STARTS WITH & ENDS WITH
STARTS WITH uses a wildcard at the end. The name "Johnson, Kate" would be returned, but not "Smith, John"
ENDS WITH uses a wildcard at the beginning:
It would return "Smith, John" but not "Smith, Johnny"
LIKE
Use the LIKE comparison to enter your own wildcard combination. It is useful for more complex comparisons, such as: