I have to update all phone numbers that start with 00 by replacing the 00 with a '+' prefix. I must replace only the first occurrence of 00 and nothing else.
phone_number: 000258843300081
ActualResult: +02588433+081
ExpectedResult: +0258843300081
Incorrect Query Used:
UPDATE [dbo].[phone]
SET phone_number = REPLACE(phone_number, '00', '+')
WHERE phone_number_numeric LIKE '00%'