I have a list of first names and I need to query all the ones that end in a certain letter. I'm not sure what you would call this so I don't really know what I'm looking for. I would be grateful for any guidance.

Nevermind I found what I'm looking for.. I'll use the wildcard

SELECT *
FROM table_name
WHERE fname LIKE '%A';

I'll put it here just in case someone else needs it.

Thanks!

Two more options for you:

and of course if the lname ends in a lower case a then

SELECT *
FROM table_name
WHERE upper(fname) LIKE '%A';