Arnold,
You might have to fully qualify the field names as desc is a keyword.
Something like
Select item from myfile where myfile.desc = 'Candle Holder'
regards

>Hi Everybody
>I have a following table
>
>Item Desc
>A Candle
>B Holder
>C Candle Holder
>
>I want to retrive a record with both "Candle" and "Holder" in the field of Desc.Target is the third record - Item C
>But how to do I preform by SQL statement ? I don't want to uses AT() or $ becuase I need rushmore for optimizes my query by where = something (Desc is indexed field) as the table have more than 300,000 records.
>
>Thanks for any comment in advance
>
>Arnold