Q:

SQL Server: How do I sort and compare lots of versions?

In my request to a table I have to find all the lines with versions where versions are less or equal to 10.0.1703 (<= 10.0.1703) and there is plenty of versions there. I use SQL Server. 
 Example of the lines needed in result is:

id | name | build(version)
--------------------------
1  | A    | 10.0.1703
2  | B    | 6.3.9600

I have to find all versions older or equal to 10.0.1703 . 6.3.9600 is less than 10.0.1703
It is connected with this question, but the solutions offered are hard to understand for me 
How to compare software versions using SQL Server?

A:

one way would be to cast as hierarchyid
WHERE CAST('/' + build + '/' AS HIERARCHYID) <= CAST('/10.0.1703/' AS HIERARCHYID) 

DEMO

