LIKE

LIKE([Owner], 'Ol%g')

Syntax

LIKE(text expression, pattern)

Logical function returns TRUE if expression matches the defined pattern, and FALSE otherwise.

text expression: Text created using text functions, text fields or constants.

pattern: LIKEoperator is used to match text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the LIKE operator will return TRUE.

There are two wildcards used in conjunction with the LIKE operator:

  • The percent sign (%)
  • The underscore (_)

The percent sign represents zero, one, or multiple numbers or characters. The underscore represents a single number or character. These symbols can be used in combinations. If either of these two signs is not used in conjunction with the LIKE clause, then the LIKE acts like the equals operator.