title: Removing characters from a alphanumeric field SQL
body: <p>Im moving data from one table to another using insert into. in the select bit need to transfer from column with characters and numerical in to another with only the numerical. The original column is in varchar format.</p>
  
  <p>original column -<br>
  ABC100
  XYZ:200
  DD2000</p>
  
  <p>Wanted column
  100
  200
  2000</p>
  
  <p>Cant write a function because cant have a function in side select statement when inserting</p>
  
  <p>Using MS SQL</p>