title: How to update the first digit of a number only?
body: <p>I need to update the first digit of numbers.
  For example, 3003.</p>
  
  <p>I only want the first '3' to be changed to '2' and don't want the last digit '3' to be changed.</p>
  
  <p>Something like the following faulty query:</p>
  
  <pre><code>update table
     set defaulttopicorder = replace(defaulttopicorder, left(defaulttopicorder,1), 2)
   where ....
  </code></pre>