>>You cannot sort records properly with the index like that.
>
>
>Can you explain your statement more? The sort is correct, when I look at the table with the index applied(sp?).

The ALLTRIMs lump everything together. IOW, the same combination could be created from totally different parts. For example

First Name  Last Name      INDEX ON ALLTRIM(FirstName) + ALLTRIM(LastName)
JON         ATHANWAN   --> JONATHANWAN
JONATHAN    SMITH      --> JONATHANSMITH

That index will put the second record first which is incorrect.