You can include wildcard characters in the where clause to search for unknown characters or to group data according to common features. This section describes pattern matching using SQL and Transact-SQL. For more information on pattern matching, see the Reference Manual: Commands.
