+ 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
2 Answers
+ 1
update company set name = replace(name,'A','') and so on
0
select * from tblcompany c where name = ('wipro',.......... so on') for update