The index could be build like (assuming that the maximum lenght for the numeric field is 10 digits):
INDEX ON PadL(Alltrim(MyNumField), 10, "0") + MyCharField1 + ...

With SET EXACT OFF, a search could be done like:
IF Seek(PadL(Alltrim(SearchValue), 10, "0"))
...
ENDIF

HTH

>I need to add some indexes to a grid so the grid will be sorted from left to right on all columns.
>The problem is that I can have one numeric field in the grid as the leftmost column. If I use STR() then the order is not right anymore. If I use PADL(ALLTRIM(...)) then I cannot search in the grid using the numeric field (I have a 'look for' option).