replace a substring in a table

[dirk]

Hello everyone,

I need to replace part of a sting in a varchar field.
The field itself contains phone numbers. About 1500 of them
are formatted like this : [phone] wheras I want them
to be like : [phone]. I tried with 'replace' but this only
replaces an exact match, i.e. the '(0)' thing can be sometimes
on the fourth or third position in the string.
Any ideas ?

TIA

Dirk