You are viewing a single comment's thread. Return to all comments →
A simple soln for MS SQL server:
select distinct city from station where (left(city,1) not in ('a','e','i','o','u') and right(city,1) not in ('a','e','i','o','u'));
Weather Observation Station 12
You are viewing a single comment's thread. Return to all comments →
A simple soln for MS SQL server: