Depending on how you intend to get at the information, you may be able to use SQL which works this way by default. You would have tags on each field then use the ORDER BY clause to indicate the proper order. This also won't be as picky about construct when finding records.

EX:

SELECT * FROM MyTable ORDER BY ID,SOMENAME,SOMEDATE ......


Bob



>Is there a way to specify a multi-column index expression with columns of differing data types without doing a type-conversion operation?
>
>Example: Table has columns:
>

>id       N(4)
>somename C(20)
>somedate D
>

>
>And I would normally make a multi-column index expression such as this:
>
>

>index on str(id)+DTOC(somedate,1) to blah
>

>
>This strikes me as being inefficient, since the DTOC() and STR() functions would need to be run on the column data, and I am wondering if you can do this another way.
>
>Thanks