>>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
>
>Try
>
>INDEX ON padl(column1, 2, '0') + padl(alltrim(column2),15,'0')
Works very well. Thank you!
"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