title: sorting string numeric values in SSRS 2008
body: <p>I have a varchar field (i am grouping on) in a dataset that returns a list of values : 20, 25, 40, 100, 110, 'N/A'..</p>
  
  <p>I want the "numeric" values sorted from low to high : i.e : 20, 25...110, 'N/A'</p>
  
  <p>the problem is that the A>Z sorting in the grouping gives out the following output :</p>
  
  <p>100, 110, 25, ..., N/A</p>
  
  <p>I cannot convert to numeric datatype since there are string values..</p>
  
  <p>Does anyone have a solution please ?</p>
  
  <p>Thank you in advance
  Jam</p>