+ 1

Write a SQL query to delete vowel's (A,E,I,O,U) from below records under name column ?

Table : Company Name Wipro IBM Accenture TCS Unisys

27th Nov 2016, 6:30 AM
Badri Raj Ar Royal
Badri Raj Ar Royal - avatar
2 Answers
+ 1
update company set name = replace(name,'A','') and so on
27th Nov 2016, 12:53 PM
Drauchris
Drauchris - avatar
0
select * from tblcompany c where name = ('wipro',.......... so on') for update
3rd Jan 2017, 3:18 PM
Usman Mirza
Usman Mirza - avatar