like
Determines if "string1" matches the pattern of "string2", with the character "char" optionally used to escape characters in the pattern string.
Syntax
string1 LIKE string2 [ ESCAPE char ]Example 1
[PRODUCT_LINE] like 'G%'Result
All product lines that start with 'G'.
Example 2
[PRODUCT_LINE] like '%Ga%' escape 'a'Result
All the product lines that end with 'G%'.