How to Sorting rows in date wise in sql server 2005?

Question

I want to sort multiple rows in date wise in sql server 2005..

 

First I create a table "StuInfo" and two attributes StuName, AdmissionDate their datatype are varchar2(20).

Then Insert multiple rows... 

After Insert I try to sort inserted rows in date wise with assending  order.

 

command is:

select *from StuInfo order by AdmissionDate desc;

but does not sorting properly....

 

Screen Shot bellow....

 

 

 

 Then I try sort inserted rows in date wise with dessending order.

but does not sorting properly.... 

 

 

 

 I want to sort.... assending/desending order that is (assending order):

 

Roll	StuName	AdmissionDate
15	Shyam Das	09-Apr-2014
12	Madhu das	02-May-2014
18	Jadu Das	05-May-2014
20	Rabin Das	10-May-2014
10	Ram Das	10-May-2014
14	Rabi Das	22-Jun-2014

 

 Please Help me.