Display the NAME of all employees who have atleast one VOWEL in their last name.

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 272
SELECT * 
FROM employee
WHERE Name like '%a%'
or Name like '%e%'
or Name like '%i%'
or Name like '%o%'
or Name like '%u%'

Comments or Responses

Login to post response