Change your DB.
Never store date values as strings: it makes it easy for you to set up and insert, but it always creates problems like this whenever you try to use the data. Store it in a DATE or DATETIME column instead, and this becomes trivial:
SELECT * FROM MyTable ORDER BY Dated
With VARCHAR or NVARCHAR storage, that is horrible, because the default comparison is character-by-character and to order by "proper" date means converting the string to a DATE first (and dealing with the inevitable user errors) or splitting the string and ordering by a number of fragments.
Seriously, it may seem like a lot of work to fix the DB design errors, but it's a lot less work in the long term.
Submit an article or tip