SELECT * FROM nome_tab WHERE nomi='A%' oppure
SELECT * FROM nome_tab WHERE nomi LIKE 'A%'