Simple Question from an idiot . .

[warthogweb]

I want to replace one string in a column - for example, a whole lot of 'catsanddogs' with 'Cats and Dogs'. The tablename is 'berg' and the field name is 'type'.

Thanks,
Martin

[Banfa]

Try

UPDATE berg SET type="'Cats and Dogs" WHERE type="catsanddo gs";

backup your data first.

[warthogweb]

Brilliant - to the point & perfect! Thanks so much!
Martin