مرتب سازی در فیلد تورا به خدا جواب بدید

[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

[mohkhosh]

mitooni ye query besazi va ba estefade az command RIGHT (FILDE MOREDE NAZAR;TEDAD KARAKTER) JODA KONI BAD OON FIELD RO SORT KONI MSLE
LEFT(RIGH(DATE;8);4)SHOD
OMIDVARAM GETREFTE BASHI