title: SQL sort by version "number", a string of varying length
body: <p>I'm trying to create an SQL query that will order the results by a version number (e.g. 1.1, 4.5.10, etc.)</p>
  
  <p>Here's what I tried:</p>
  
  <pre><code>SELECT * FROM Requirements 
      WHERE Requirements.Release NOT LIKE '%Obsolete%' 
      ORDER BY Requirements.ReqNum
  </code></pre>
  
  <p>Now, the ReqNum field is a string field and unfortunately I can't change it to a float or something like that because I have requirement numbers like <code>162.1.11</code>.</p>
  
  <p>When I get the results back, I'll get ordering like this:</p>
  
  <pre><code>1.1
  1.10
  1.11
  1.3
  </code></pre>
  
  <p><strong>How can I write a query that will sort by lexicographic order?</strong> </p>
  
  <p>... or,</p>
  
  <p><strong>How can I correctly sort the data?</strong></p>
  
  <p>Thanks for the input in advance!</p>