In a table,i want to delete particular text from every column how can i do that ,in my table i have 17000 records,
i want to delete this "123" from all the columns,
i used query
set occupation = replace(occupation, '123', '') where createDate='2007-12-1 00:00:00'
when i excecuted it showing error as "Argument data type text is invalid for argument 1 of replace function."
Datatype is "text" null, above member is tablename,occupation is column name,how can i solve this help me.