pattern
Is a literal string. Wildcard characters can be used; however, the % character must come before and follow pattern (except when you search for first or last characters). pattern is an expression of the character string data type category.
expression
Is an expression, typically a column that is searched for the specified pattern. Expression is of the character string data type category.