title: Replace first Letter in a field Oracle
body: <p>Hi Guys I have this Table
  <img src="https://i.stack.imgur.com/EvXt6.png" alt="My Original table"></p>
  
  <p>I need to replace the First Letter in ACCT_NAME with the First Name of ACCT_SHORT_NAME. Records like the Higliighted(RAFFMAN) should not be changed. I have tried:</p>
  
  <pre><code>select acct_name, ACCT_SHORT_NAME,replace(acct_name, substr(acct_name, 1, 1),      ACCT_SHORT_NAME)
   from tbaadm.gam where schm_type = 'TDA' and rcre_user_id  = 'SYSTEM' and substr(acct_name,2,1) = ' '
  </code></pre>
  
  <p>I am getting:</p>
  
  <p><img src="https://i.stack.imgur.com/Mvl1k.png" alt="Table after select"></p>
  
  <p>This means that am Picking the whole value in ACCT_SHORT_NAME. WHat is the best way to do what am trying to do?</p>