title: Replace ONLY the first occurrence of a string in SQL
body: <p>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.</p>
  
  <pre><code>phone_number:     000258843300081
  ActualResult:     +02588433+081
  ExpectedResult:   +0258843300081
  </code></pre>
  
  <p><em>Incorrect Query Used:</em></p>
  
  <pre><code>    UPDATE [dbo].[phone]
      SET phone_number = REPLACE(phone_number, '00', '+')
      WHERE phone_number_numeric LIKE '00%'
  </code></pre>