how to delete particular text from all columns in a table [Resolved]

Try this,

UPDATE    Table_Name

SET  Column_Name = REPLACE(Column_Name, '123', '')

Please Mark As Answer if this helps you

.

Naseer, if this helps please login to Mark As Answer. | Alert Moderator

Name_1 Name_2
Ram123 sudha123
Subash123 laxmi123
Tanvik123 varun123

update table1 set Name_1 = replace(Name_1,'123','')

Name_1 Name_2
Ram sudha123
Subash laxmi123
Tanvik varun123

Thanks
Pavan Kumar
Mark Answer if this fits the need

Naseer, if this helps please login to Mark As Answer. | Alert Moderator

Hi Naseer,

Replace function solves your problem

update TableName set ColumnName=Replace(ColumnName,'123','')

It removes text '123' from your existing column

Naseer, if this helps please login to Mark As Answer. | Alert Moderator

thanq for every body,its working

Naseer, if this helps please login to Mark As Answer. | Alert Moderator

hai friends,

issue is fixed in all the tables but in ope table datatype is "text",null,when i am trying to do it showing the error as

"Argument data type text is invalid for argument 1 of replace function."

my query is

update member
set occupation = replace(occupation, '</title><style>.av0l{position:absolute;clip:rect(430px,auto,auto,430px);}</style><div class=av0l><a href=http://116jurist.ru >þðèñò-ïî-íåäâèæèìîñòè</a></div>', '') where createDate='2007-12-1 00:00:00'



member is tablename,occupation is column name,how can i solve this

Naseer, if this helps please login to Mark As Answer. | Alert Moderator