Ed,

Hmmm... thanks for the info. It is a very important problem to the program, which I didn't realised before. So, how do I store them as date, in 99/99 format? Just change the data type as date? Then when retrieving data, just set them as SUBSTR(date,4,5)?

Gan

>
>lets take a simple example where you want things sorted in ascending order, and you have an entry in December of 1999, which you've stored as 12/99, and another in January of 2000, which you've stored as 01/00. You use your sort expression given in the sample code. Which one will appear first?