title: How to remove letters from beginning and end of varchar column in SQL when not authorized to use UPDATE function
body: <p>I have a <code>varchar(20)</code> column in SQL that contains some values with letters in the beginning and/or end of the value (i.e. AD5376276 or AD574638BD or 324523BD). </p>
  
  <p>I want to eliminate any letters from these values in this column so the result will be only numeric character values. I am doing this in SQL. </p>
  
  <p>I have being trying something along the lines of this in SQL </p>
  
  <pre><code>SELECT 
      LTRIM('%[a-z]%', txn.transaction_number) 
      RTRIM(txn.transaction_number, '%[a-z]%')
  FROM 
      arrt.tblAgingTransactionDetail_DailyR txn;
  </code></pre>
  
  <p>Thanks!</p>