- To identify partial matches, SQL uses two wildcard characters. The percent sign (%) can stand for any string of characters that have zero or more characters. The underscore (_) stands for any single character. Table 9-3 provides
- some examples that show how to use LIKE.
WHERE Phone NOT LIKE ‘503%’
This example returns all the rows in the table for which the phone number starts with something other than 503.