Solved: date format in vcarchar

[shamsam1]

i have stored date in var char i need to order by date ,month, then order by year..i need sql query for this

22/01/2008
01/02/2006
05/12/2007

[shamsam1]

[VBA]
order by month(convert(datetime,'string', 105)) desc,day(convert(datetime,'string', 105)) desc,year(convert(datetime,'string', 105))desc
[/VBA]