>Hi Again Folks,
>
>Here's how I got around the problem (see the original post for a description of the problem).
>
>I changed the index expression to
>
>
index on str(priority) + chrtran(ttoc(messagesent,1), '0123456789', '9876543210') tag priority addi
>
>Works like a charm!
>
>I'd still love to know why the original failed though.
>
>Cheers,
>
Your original filaed because you tried to use the STR() function on a date expression, which is illegal.
Why you got the message you did, instead of a type mismatch error is beyond me.
Erik Moore
Clientelligence