title: How to compare SQL strings that hold version numbers like .NET System.Version class?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/11364242/how-to-compare-software-versions-using-sql-server">How to compare software versions using SQL Server?</a>  </p>
  </blockquote>
  
  
  
  <p>I am a complete and utterly new to sql, but today I found an error in a sql query here at work that is very important. So I could use some help:</p>
  
  <p>Given an sql string that represents a product version</p>
  
  <p>'15.0.0.0'</p>
  
  <p>is there a foolproof way to sort or compare that string similar to how .NET class <a href="http://msdn.microsoft.com/en-us/library/system.version.aspx" rel="nofollow noreferrer">System.Version</a> compares instances?</p>
  
  <p>So, given such a hypothetical construct, or function or what-ever, I would expect that '15.5.568' would be greater than '15.0.0.0'.</p>
  
  <p>Thanks</p>