Update employee name replacing vowels (a,e,I,o,u ) with #.

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 282
UPDATE EMPLOYEE SET  EMPNAME=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(EMPNAME,'A','#'),'E','#'),'I','#'),'O','#'),'U','#')

Comments or Responses

Login to post response