See Considerations for Creating Index Expressions in the help

TTOC(sdatetime,1)+phone+STR(id1)+STR(id2)

Why do you need such index in the first place?


>
>I have the following index:
>
>

ALLTRIM(TTOC(sdatetime)+ALLTRIM(phone)+ALLTRIM(STR(id1))+ALLTRIM(STR(id2)))

>
>When I try to populate the table (alias), I get error message:"Error building key for index"