>I have a table that has a field with the first word begging with the same name (ie. bean green and bean pork) I would like to do a search by typing in either partial or full word bean and view all results. The following isn't working. Any direction appreciated.
>
>

>Descr = UPPER(thisform.text2.Value)
>
>lcSave = thisform.grid1.RecordSource
>thisform.grid1.RecordSource = ""
>SELECT  Name, MA, Buyer, Item, Pack, Size, Brand, Descriptio as Description;
>FROM sporder;
>where descriptio like DESCR ;
>ORDER BY Description;
>into CURSOR sorder
>thisform.grid1.RecordSource = lcSave
>
>thisform.grid1.recordsource = "sorder"
>
>

http://www.techonthenet.com/sql/like.htm

Descr = UPPER(thisform.text2.Value) + "%"
* etc.