Garrett,

Yeah, Ed mention the Y2K problem which I didn't realised it b4. Thanks for the info.

:)
Gan

>>I guess your tip will help. I'll put an extra field in my cursor as,
>>
>>SELECT substr(month,5,2)+substr(year,4,2) AS mysort FROM.... ORDER BY mysort
>>
>>since it can kill 2 birds with one stone, as how Ed stated.
>
>If you're going to put an extra field in, why don't you use the full date? That way, you don't have any Y2K issues on the sorting.