Hi Aritra

Thanks for your input.But LIKE is not optimizable.

Arnold

>Hi Arnold
>
>As far as I understand A,B,C are record and DESC is a field.
>
>You can try like
>
>SELECT * FROM ITEM ';
>WHERE DESC LIKE 'CANDLE HANDLE'
>
>Aritra