title: How to order query result by multipart X.Y[.Z] "version" numbers?
body: <p>I have this data: </p>
  
  <pre><code>nov_id
  2.1.1 
  2.1.10
  2.1.11
  2.1.12
  2.1.13
  2.1.14
  2.1.2 
  2.1.3 
  2.1.4 
  2.1.5 
  2.1.6 
  2.1.7 
  2.1.8 
  2.1.9 
  2.2   
  2.3   
  2.4   
  2.5   
  2.6   
  </code></pre>
  
  <p>I need to order my results so my result expected is this:</p>
  
  <pre><code>nov_id
  2.1.1 
  2.1.2 
  2.1.3 
  2.1.4 
  2.1.5 
  2.1.6 
  2.1.7 
  2.1.8 
  2.1.9 
  2.1.10
  2.1.11
  2.1.12
  2.1.13
  2.1.14
  2.2   
  2.3   
  2.4   
  2.5   
  2.6   
  </code></pre>
  
  <p>This is one of my tries:</p>
  
  <pre><code>Select nov_id 
  From dbo.NS_tbl_sc_novedad
  Order by Convert(int,Left(Ltrim(Rtrim(replace(nov_id,'.','')))+'0000',4));
  </code></pre>
  
  <p>I tried to paste some zero's and order by that but, obviously I don't get it yet.</p>