Saturday, June 4, 2016

SQL vowel at beginning and end



select distinct city
from station
where lower(substr(city,1,1)) in ('a','e','i','o','u') and
( lower(city) like ('%a') or
lower(city) like ('%e') or
lower(city) like ('%i') or
lower(city) like ('%o') or
lower(city) like ('%u'));

No comments:

Post a Comment