thanks for reply

but it is not working. bellow is my sql statement.

SELECT *

FROM Item

WHERE CONTAINS(ItemName, '"*endant"');

this statement returns me 0 rows but if i used it in following...