LIKE( ) Tests if a string matches a pattern. Syntax LIKE(str, pattern) str The string to evaluate. pattern The string pattern to match. You must enclose the pattern in double quotation marks (" "). 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 that contains 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 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 that start with D: LIKE([customerName], "D%") The following example returns true for productCode values that contain 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")
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy