select distinct city from station where city like "[a,e,i,o,u]%" MSsql

SELECT DISTINCT CITY FROM STATION WHERE UPPER(SUBSTR(CITY, 1, 1)) IN ('A', 'E', 'I', 'O', 'U');

SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%'; The LIKE operator in SQL is used for pattern matching within strings. In this query, LIKE is employed to check whether the CITY column values begin with specific vowels. The % symbol in SQL is a wildcard used with the LIKE operator. It represents zero or more characters, allowing you to match patterns with flexible lengths.

select distinct city from station where left(lower(city),1) in ('a','e','i','o','u');

select distinct(CITY) FROM STATION WHERE SUBSTRING(CITY,1,1) IN ('a','e','i','o','u')