find and replace in all fields of a database

[v3nt]

hello there - i can't seem to find an answer on the forum (maybe search terms to popular or vague)

i need to replace "???s" with "'s" in all tables and fields in a database. What would the SQL statement be?

best, Dan

[dagon]

the basic line is:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

you then need to create a loop for tables and one for fields.