You are here: Functions > FIND() > Finding Multiple Strings in a Record

Finding Multiple Strings in a Record

If you leave the field parameter blank, the FIND() function searches for the string in the entire record based on the appropriate character set for the record based on the field definitions.

To search for both the string “lawyer” and the string “chicago” anywhere in the record, enter the following condition in a command or as a View filter:

FIND("lawyer chicago")

Analyzer searches the table and identifies those records that have both “lawyer” and “chicago” anywhere in the record. This is because Analyzer treats any blank space between the strings as a string separator, not as a blank space.