Hi,
I need to index a cursor on two columns, one is type NUMERIC(2,0) (COLUMN1) (the value is always a hole number, 1,2,5,3, 12); the other column (COLUMN2) is c(15) but I need to show the values in the order converted to a number. For example, the second column values could be:
'3330023'
'23'
'5667'
'9900'
And I need to have them shown in their "numberic" order as
'23'
'5667'
'9900'
'3330023'
The index has to be an expression that has +. For example,
COLUMN1 + INT(VAL(COLUMN2))
But obviously the above will not give me what I am looking for.
TIA for any input
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham