using WHERE LIKE and end %

SELECT * FROM Company
WHERE City LIKE '%d'

selecting the Company  city that ends with an "d" from the Company table.