title: Sql query to sort numbers & to get output as 1.1.1,1.1.2,1.1.3
body: <p>I want sql query to get output as </p>
  
  <p><code>1.1.1,1.1.2,1.1.3...</code></p>
  
  <p>I tried order by clause but I am getting result as <code>1.1.1,1.1.10,1.1.11,1.1.2,1.1.3...</code></p>
  
  <p>My procedure is:</p>
  
  <pre><code>select * 
    from Projects,
   where iId in (select value 
                   from ParmsToList(@projectid,',')
                )
     And Projects.categoryid  &gt; 0
   order by Projects.vProjectName
  </code></pre>