A literal string. Wildcard characters can be used; however, the % character must precede and follow the pattern (except when searching for first or last characters). The pattern argument is an expression of types that can be implicitly converted to nchar, nvarchar, or ntext.
An expression, usually a column that is searched to find the specified pattern. The expressionargument can be nchar, nvarchar, or ntext.