In the FPW2.6a version of the app I wrote, I used lots of SET FILTER statements to allow users to find things. Now I now better (yes, I did learn from Jim Booth and company's Top Ten Stupid VFP Coding list!).

What I am trying to do is implement a search and filter class that will let the user enter a phrase and have it search the document titles for that phrase (a CONTAINS search)

In the old days it was:

use q:\qa\qdms2000\qdms!document
set filter to m.Searchtext $ title
brow

Now (as I understand it) the way to do this is with an SQL statement:

select * from q:\qa\qdms2000\qdms!document where l_cSearchtext $ title into cursor temp

and then use this cursor as the basis for the grid's record source?

I have lots of places where this is used in the app, and I wanted to make sure this is the right approach before starting down the road....

Thanks!