Re: replace a substring in a table

[Felix Geerinckx]

dirk wrote:
> 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.

It doesn't matter where or how many '(0)'-substrings you have: they are all removed if you use

SELECT REPLACE('+32 (0)51 12(0)345(0)', '(0)',''); --> [phone]

--
felix
Please use BBCode to format your messages in this forum.