Cacher is the code snippet organizer for pro developers

SELECT DISTINCT CITY FROM STATION WHERE SUBSTRING(CITY, 1, 1) IN ('A','E','I','O','U')
OR LEFT(colName, 1)
OR RIGHT(COLNAME,1)