title: Extract alphanumeric value from varchar column
body: <p>I have a table which contains a column having <strong>alphanumeric</strong> values which is stored as a string. I have multiple values in that column having values such as <code>F4737</code>, <code>00Y778</code>, <code>PP0098</code>, <code>XXYYYZ</code> etc.</p>
  
  <p>I want to <strong>extract values starting with a series of F and must have numeric values in that row.</strong>
  Alphanumeric column is the unique column having unique values but the rest of the columns contain duplicate values in my table.</p>
  
  <p>Futhermore, once these values are extracted I would like to pick up the <strong>max value</strong> from the duplicate row,for eg: </p>
  
  <p><em>Suppose I have <code>F4737</code> and <code>F4700</code> as a unique Alphanumeric row, then <code>F4737</code> must be extracted from it.</em></p>
  
  <p>I have written a query like this but the numeric values are not getting extracted from this query: </p>
  
  <pre><code>select max(Alplanumeric) 
  from Customers 
  where Alplanumeric '%[F0-9]%
  </code></pre>
  
  <p>or </p>
  
  <pre><code>select max(Alplanumeric) 
  from Customers 
  where Alplanumeric like '%[0-9]%' 
  and Alplanumeric like 'F%'**
  </code></pre>
  
  <p>I run the above query but I am only getting the F series if I remove the numeric part from the above query. How do I extract both, the F starting series as well as the numeric values included in that row?</p>