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