title: Replace start of string in SQL
body: <pre><code>SELECT REPLACE([strUrl], '/myoldurl', '/mynewurl') FROM [UrlRewrite]
  </code></pre>
  
  <p>If <code>strUrl</code> is <code>/myoldurl/myoldurl_something_else</code>, it returns <code>/mynewurl/mynewurl_something_else</code>. I want it to be <code>/mynewurl/myoldurl_something_else</code>. </p>
  
  <p>How do I just replace from start of string in SQL?</p>