Update employee name replacing vowels (a,e,I,o,u ) with #.
Posted by
Bandi under
Sql Server category on
1/30/2015 |
Points: 40 | Views : 1278
UPDATE EMPLOYEE SET EMPNAME=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(EMPNAME,'A','#'),'E','#'),'I','#'),'O','#'),'U','#')