INDEX ON Lastname + IIF( LEFT(firstname,1)="K", "1", "2") ...
>i want to create an index that should sort in the following order:
>
>Example:
>
>"Lastname" + all firstnames that start with lets say "K" should be on the top and the others should be under "K" in any order.
>
>i hope its clear.
>
>any help would be highly appreciated!
--sb--