I'm using SQL table names to display titles for a series of drop down boxes. The problem is that there are several tables with the same name but with an extra letter on the end, ie. Table, TableA and TableB. I need to display the table name on the page without the extra letter at the end - is there any way that you can check if the last letter of the table name is a capital letter? Then I could just remove it, but I'm not sure how to go about checking.