Can anyone tell me how to convert an alpha numeric value to a number (dec, int, whatever), so i can use that field to sort by in numeric order?

example:

TABLE FILE Z1
PRINT
PRI/A3
NAME/A100
STORY/A8
REQ/A8
REQ_TYP/A2
REQ_DT/MDYY
DUE_DT/MDYY
REQ_BY/A25

BY LOWEST PRI NOPRINT

The PRI/A3 (priority)data ranges from 1 through 310, and sorted this way is recognized as alpha numeric and out of order (by numerical standards)

A3 output 1,100,110,2,220,230 ect....

This message has been edited. Last edited by: FP Mod Chuck,

Tim

Use a DEFINE as below.


DEFINE FILE Z1
PRI_INT/I11 = EDIT(PRI);
END


Another option, depending on the contents of the field, is to change the format of the field in the master file.

Outstanding, thanks Chuck