>Hi all,
>I need to order a cursor by a character field that contains numeric values (1,3,4,5,5bis,7..and so on). I cannot change the type of the field, but i want that number 5bis and 6 has a order before than 13. Some trick?
>Thanx
SELECT YourCursor
INDEX ON VAL(TheField) TAG YourCursor
BROWSE NORMAL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.