مرتب سازی access.مهم

[farhadamin]

salam az komaketon mamnon
man baram in masalee khili mohemee. inja toyee kharej daram zayee misham
mikha adad toyee ek fild ro moratab konam
adad be soratee
12-3444-1998
13-3144-1999
15-3944-2000
man mikham adad bar asas ghesmatee dovom moratab besham na baz asas sal rahi pay da nakardam )manzoram 3344( ast.
omidvaram khili zod komakam konid.
mamnon az komak

[AminSobati]

SELECT * FROM MyTable
ORDER BY SUBSTRING(MyColumn,6,4)