I would like to move an app from 2.6 to VFP5. Basically the app searches on field information and displays the results. One field is a 60 character description field. A person may want to search for "MAIN STREET" and then visually scan the results for the exact record desired. The 2.6 version uses a sql select and a cursor to display the results in a browse. I would like to use a parameterized view in VFP to do the same.

Is it possible to use something like:

SELECT * ;
FROM SHAREDWO ;
WHERE cDescription $ SHAREDWO.DESCRIPT

where cDescription is a passed parameter? I'm not having much success.