LIKE

    2. WHERE CustomerName LIKE 'a%'; //The following SQL statement selects all customers with a CustomerName starting with "a"
    4. WHERE CustomerName LIKE '%a'; //The following SQL statement selects all customers with a CustomerName ending with "a"
    6. > SELECT * FROM Customers
    9. > SELECT * FROM Customers
    10. WHERE CustomerName LIKE '_r%'; //The following SQL statement selects all customers with a CustomerName that have "r" in the second position
    11. > SELECT * FROM Customers
    12. WHERE CustomerName LIKE 'a__%'; //The following SQL statement selects all customers with a CustomerName that starts with "a" and are at least 3 characters in length
    14. > SELECT * FROM Customers
    15. WHERE ContactName LIKE 'a%o'; //The following SQL statement selects all customers with a ContactName that starts with "a" and ends with "o"
    17. > SELECT * FROM Customers