>I am hung up on an index again and need some help with this post you made to me about AllTrim in an index.
>
>My Index is set on employeenumber+DTOC(weekDate)+JobNumber.
>
>The data in this fields is variable length.
>
>My Select statement is
>
>Select * From ntimetbl Where emp1no+DTOC(wend)+jobno == checkthisentry InTo Cursor myVerifySingle
>
>This will not work unless I use
>Select * From ntimetbl Where AllT(emp1no)+DTOC(wend)+AllT(jobno) == checkthisentry InTo Cursor myVerifySingle
>
>Which I am not sure takes advantage of the index.
>
>Please help me to understand.
Make search expression fit to index signature (assuming your index: emp1no+DTOC(wend)+jobno):
Select * From ntimetbl ;
Where emp1no+DTOC(wend)+jobno == ;
padr(m.emp1no,fsize('emp1no','ntimetbl'))+dtoc(m.dVar)+m.jobno ;
InTo Cursor myVerifySingle
PS:Dtoc(m.dVar) is dependant on current date setting. dtoc(m.dvar,1) would be safe.
Cetin