Sunday, November 1, 2009

Using Replace function to update whole column data in a table

Below is the table "tbl_interview" with the "description" column and we are updating "script src=" text with the blank "" text.

update tbl_Interview set description=Replace(description,'script src=','')