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

Posted by Bandi under Sql Server category on 1/30/2015 | Points: 40 | Views : 1427

SELECT * 
FROM employee
WHERE Name like '%a%' 
 or Name like '%e%'
 or Name like '%i%'
 or Name like '%o%'
 or Name like '%u%'

Bookmark It

Latest Code Snipptes