I do belive that TIME(start) caused the problem because the index key would evaluate to new value each time it was calcualted.
>
>I have since tried it with your solution and with ALSO with the EMPNO+DTOS(DATE)+DUTY+EXCCODE+STRTRAN(SUBSTR(TTOC(START),12,5),":").
>Both do not display the phantom record now.
>
>I can only assume that the index was corrupt... though I am sure I did try PACK and REINDEX before. I cannot duplicate the problem anymore. This could be because I physically deleted the CDX and started afresh (?)
>
>My argument has been, throughout this thread, is that, even if the expression was incorrect, as long as it evaluated to a legal expression (which it would have to), why the phantom record..
>
>Sorry for the back and forth, I am really curious to understand what causes this problem.
>
--sb--