The CONTAINS function returns true if a sting is found inside another string. The comparison is not case sensitive.
#CONTAINS(haystack, needle)
Arguments:
- haystack: The string to search.
- needle: The string to find in the haystack.
Returns:
- True if the second string is found in the first. Otherwise, false is returned.
Example:
WHERE #contains(ebay.title, 'Odd')
eval ebay.title
The Where command populates the Working Set with only products where the text "Odd" appears in the eBay Title.