order by 1.99.10 and 1.99.9 sql server

Question

Sorry about my mistake, I should provide the real sample for the question, my ID included characters inside:

sample code:

select ID from student order by ID

Expected output from mine          but system output
-------------------------          -----------------
JAD.1.99.9                             JAD.1.99.10
JAD.1.99.10                            JAD.1.99.9

and this ID is of nvarchar type.

Answer 1

Yesterday there was a similar question where i have learned that you can use hierarchyid for version sorting(if you use at least SQL-Server 2008):

SELECT id 
FROM   student 
ORDER  BY Cast('/' + Replace(id, '.', '/') + '/' AS HIERARCHYID) 

DEMO