|
View previous topic :: View next topic
|
| Author |
Message |
roopesh_vp
Currently Banned
New User
Joined: 30 Jan 2009
Posts: 2
Location: Mysore
|
|
|
|
Hi All,
I want to sort a ps based on the value of the clumn 'last used'( some sample values for that column is given below)
LAST USED
02/20/09
12/07/07
01/31/08
12/28/06
*NEVER*
01/16/09
02/13/09
*NEVER*
*NEVER*
04/04/07
*NEVER*
08/24/06
It has both date fields and the string *NEVER* .. Can i sort this field in descending order of date and move all *NEVER* records to the botton of the file??? Is it possible to do this using a COBOL program or easytrieve...??
Thanks in advance |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
since numbers are represented as hex F0 (0) thru F9 (9) and letters/special characters are represented as hex C1 (A) thru E?,
you are not going to be able to desc sort without changing the value of '*never*' to something like '9never*'. |
|
| Back to top |
|
|
|
|
