Hi Arnold,

If you're looking for the text "Candle Holder" then

Select <fields> from <table> where Desc = "Candle Holder"

will do the trick. However, if you want to search for arbitrary strings within the Desc field then that can't be optimised.

Regards,

Liam


>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