title: Order by Nvarchar column containing decimal value
body: <p>I have following table and data in sql server database. I am trying to fetch data order by <code>[Version]</code>  column. I want result arranged  as follows:</p>
  
  <p><a href="https://i.stack.imgur.com/qyjz9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qyjz9.jpg" alt="enter image description here"></a></p>
  
  <p>How can i achieve this?</p>
  
  <pre><code>CREATE TABLE [dbo].[DocumentLog](
  [DocID] [nvarchar](50) NOT NULL,
  [Version] [nvarchar](50) NOT NULL) ON [PRIMARY]
  GO
  
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.1');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.5');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.3');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.4');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.2');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.6');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.7');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.9');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.8');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.10');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.11');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.12');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.13');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.14');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.15');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.16');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.17');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','0.18');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','1.0');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','1.1');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','1.10');
  INSERT INTO DocumentLog (DocID,[version])values('doc0001','2.0');
  </code></pre>