We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 6
Weather Observation Station 6
Sort by
recency
|
4191 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT city FROM station WHERE city LIKE '[aeiou]%'
Hello,
Here is my code, hope this helps someone!
select CITY from STATION where left(CITY,1) in ("a","e","i","o","u");
SELECT DISTINCT CITY FROM STATION WHERE UPPER(SUBSTR(CITY,1,1)) IN ('A', 'E', 'I', 'O', 'U');
using DB2-----
SELECT DISTINCT CITY FROM STATION WHERE LEFT(CITY, 1 ) IN ('A', 'E', 'I', 'O', 'U');