LIKE(text, mask)

The LIKE function tests whether a mask can be found in text and returns TRUE or FALSE accordingly.

The LIKE function is case sensitive.

Examples:

LIKE("This is a text string", "This") returns FALSE

LIKE("This is a text string", "This*") returns TRUE

LIKE("This is a text string", "?his is a*") returns TRUE

See also:

FINDTEXT(find_text, within_text, start_num)

SEARCHTEXT(find_text, within_text, start_num)

Other text functions