I have a cust.dbf containing a memo field cust.details

The following code has worked fine for years in VFP7

select * from cust where "price"$details

but it falls over in my new VFP9 upgrade - with "Memo file missing or Invalid"

I.E. I can run the code against the SAME table on the same PC and it is fine in VFP7, not so in VFP9.

I have tried converting the details field by using ALLTRIM(details) in the SQL command but this has made no difference - I get the same error.

Anyone got any suggestions?

Thanks
Barry Sutton