retieve the data

[cca]

Hi,

i have a table with the data is like

kt
log kt
KT
LOG KT
LOG (KT)/ KT
kt/ka

For this i have created normal index with this and used contains. I am able to retrieve the data with missing values like KT.

Can u please suggest me how to frame the query to retrieve the data without using like operator which gives fast search results.

thanks in advance.

Regards,
cca

[debasisdas]

Can you kindly post what you have tried so far.