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:
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:
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.