You are viewing a single comment's thread. Return to all comments →
Query resolved in two ways in SQL Server:
1st SELECT city FROM station WHERE LEFT(city, 1) IN ('A','E','I','O','U');
2nd SELECT city FROM station WHERE city LIKE 'A%' OR city LIKE 'E%' OR city LIKE 'I%' OR city LIKE 'O%' OR city LIKE 'U%';
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 6
You are viewing a single comment's thread. Return to all comments →
Query resolved in two ways in SQL Server:
1st SELECT city FROM station WHERE LEFT(city, 1) IN ('A','E','I','O','U');
2nd SELECT city FROM station WHERE city LIKE 'A%' OR city LIKE 'E%' OR city LIKE 'I%' OR city LIKE 'O%' OR city LIKE 'U%';