WILDCARD  characters are used to substitute one or more characters in a string and used with LIKE operator  which is used in a WHERE clause to search for a specified pattern in a column.

Syntax in SQL to use Wildcard characters –

SELECT(ColumnName(s)) FROM <TableName> WHERE<ColumnName>LIKE <pattern> ;

Examples of wildcard characters use in SQL-

Replace the word pattern provided in below example with the pattern provided in following table, its result is explained in table.

SELECT * FROM Customers WHERE CustomerName LIKE ‘pattern’;

Wildcard characters in SQL Server-