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.
we can do this
SELECT CITY
FROM STATION
WHERE (SUBSTR(CITY, 1, 1) IN ('A','E','I','O','U','a','e','i','o','u'))
AND (SUBSTR(CITY, LENGTH(CITY), 1) IN ('A','E','I','O','U','a','e','i','o','u'));
like this as well.but this is too much for such a simple one i guess. This work same as Right(city,1) and left(city,1)
Weather Observation Station 8
You are viewing a single comment's thread. Return to all comments →
we can do this SELECT CITY FROM STATION WHERE (SUBSTR(CITY, 1, 1) IN ('A','E','I','O','U','a','e','i','o','u')) AND (SUBSTR(CITY, LENGTH(CITY), 1) IN ('A','E','I','O','U','a','e','i','o','u'));