You can use the LIKE operator to select records with similar data values. In the next figure, records with a city name beginning with "B" are selected The percent sign after "b" is called a "wildcard. The result is that any city with a first letter "B" or "b" is selected. SQL is not case sensitive, select companyname, city, country from suppliers where city like 'b% COMPANY NAME CITY COUNTRY Hel sobwaren GmbH & Co. KG Berlin Germany Bigfoot Breweries Bend USA New England Seafood Cannery Boston USA To find a full projection of suppliers from any city ending in 'B' use this: select * from suppliers where city like '%' CHECKPOINT SQL 11. Write the SQL for a full projection of all customers with lastname ending in "r". Use the customers table and lastname column