I am trying to build a search screen where the top part of the screen contains text boxes for each of the fields that theuse can search on. The bottom portion of the screen is the grid that will contain the search results. I am building a cursor that is used as the resordsource for the grid based on a Select statement.

lcSby = ALLTRIM(thisform.sortby)
SELECT custno,company,contact,address1,address2,city,state,zip,county,phone from ;
customers INTO CURSOR curCustFilt ORDER BY &lcSby


thisform.sortby is set when the user clicks on any of the columns in the grid. This works fine.

I am trying to figure out how to add the where clause and I am not having much luck. I want the user to be able to populate any or all of the text boxes and have the select statement include a where clause with a like statement. For now I want to make it do a starts with but eventually I want the user to control wether they want starts with, ends with, or contains.

Any ideas?

Randy Wessels
www.screentekcorp.com