title: SQL Convert from alphanumeric to numeric only
body: <p>Ok, I have a table I am querying for an outside project.  The table has a field that is alphanumeric but the external project can only support numeric data.  The outside project is needing my data as an Excel spreadsheet so I am trying to just export my query to Excel which I can do but I can't seem to figure out if there is a simple convert feature to do this for me.  The originating table has the field as VARCHAR(10).  I tried CAST and CONVERT but no go.  This is SQL Server 2012.  </p>
  
  <p>Thanks.</p>