Do you have an index on str(ctctrannum,6)+cjobid?

I believe, there is a bug on STR() in VFP9. AFAIK it's fixed in VFP9 SP beta, so it's going to be fixed in SP. I'm not sure of workaround except finding all cases with STR in select and handling on one to one basis.

>Nadya or Naomi:
>
>I get confused. Nevermind. Anyway nice to hear from you again.
>
>Here is the code that one of the programmer found that was causing problem.
>//////////////////////////////////////////////////////////
>*!* Select Max(Month(dprdend)) As curmonth ;
>*!* from tcrec ;
>*!* where Year(dprdend) = YEAR(sys_date) And ;
>*!* cadjnum = 99 And ;
>*!* &retronum And ;
>*!* str(ctctrannum,6)+cjobid In (Select Distinct Str(ctctrannum,6)+cjobid From tcded Where Between(cwhldid, 9, 14)) ;
>*!* into Cursor 'maxmonth' + Thisform.tmpname
>
>Select Distinct Str(ctctrannum,6) + cjobid As checkid ;
> From tcded ;
> Where Between(cwhldid, 9, 14) ;
> INTO Cursor ed1
>
>Select *, Str(ctctrannum,6) + cjobid As newid ;
> From tcrec ;
> INTO Cursor tcrec1
>
>Select tcrec1.* ;
> FROM tcrec1, ed1 ;
> WHERE newid = checkid ;
> INTO Cursor ed2
>
>Select Max(Month(dprdend)) As curmonth ;
> from ed2 ;
> where Year(dprdend) = Year(sys_date) And ;
> cadjnum = 99 And ;
> &retronum ;
> into Cursor 'maxmonth' + Thisform.tmpname
>///////////////////////////////////////////////////////
>
>The one that have the comment is the original code then he brake the select in several one. Did you know a quick fix for this. Otherwise we need to get out of 9.0 until we fix all the SQL statement.