LIKE( )
Tests if a string matches a pattern.
Syntax
LIKE(str, pattern)
Argument
str
The string to evaluate.
pattern
The string pattern to match. You must enclose the pattern in double quotation marks (" "). Use the correct case when typing the characters to match; the match is case‑sensitive. You can use the following special characters in a pattern:
A percent character (%) matches zero or more characters. For example, %ace% matches any string value containing the substring ace, such as Facebook, and MySpace. It does not match Ace Corporation because this string contains a capital A, and not the lowercase a.
An underscore character (_) matches exactly one character. For example, t_n matches tan, ten, tin, and ton. It does not match teen or tn.
To match a literal percent (%), underscore (_), precede those characters with a two backslash (\\) characters. For example, to see if a string contains M_10, specify the following pattern:
"%M\\_10%"
Returns
True if the string matches the pattern; returns false otherwise.
Example
The following example returns true for values in the customerName field starting with D:
LIKE([customerName], "D%")
The following example returns true for productCode values containing the substring Ford:
LIKE([productCode], "%Ford%")
The following example uses two LIKE( ) expressions to look for the substrings “Ford” or “Chevy” in each ProductName value. If a product name contains either substring, the computed column displays U.S. Model; otherwise, it displays Imported Model.
IF(((LIKE([ProductName], "%Ford%") = TRUE) OR (LIKE([ProductName], "%Chevy%") = TRUE)), "U.S. model", "Imported Model")