>Hi Michael,
>
>- try set SET TABLEVALIDATE TO 0
>- check COLLATE of all indexes if equal to VFP COLLATE
>- check CODE PAGE of tables if equal to VFP Code Page
>- if you use function in index expression, like as STR() change to STR(n,length) - key must has fixed length
STR(n) is fixed length - 10 characters. There is a bug in VFP9 RTM that incorrrectly treats it as variable length. It has been fixed in SP1.
--sb--