title: SQL Server : string replace for variable length
body: <p>Scenario: column contains numbers as ('1234', '123', '23456') - I need to replace the first number with 'A' and replace the remaining numbers with <code>*</code>.</p>
  
  <p>Output should be:</p>
  
  <pre><code>A***
  A**
  A****
  </code></pre>
  
  <p>Can anyone help me? How to achieve this?</p>
  
  <p>Thanks</p>