Hi Guys,

I've googled this but can't find the right answer. Say I want to replace all instances of the character & in my database for 1,000's of records.

I thought it would be something like so:

Code:
update table set headline = replace('&','&');
Can anyone help?