Normally, doing a search and replace in SQL is not radically difficult. You basically do an update using the replace() function. However, if the Description column in your table is a ntext field, the above code is going to error out. The correct way around this is to cast() the column as a maximum-sized varchar() type. [More]