Discussion Locked
Problem in executing the Contains query
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
hi..
i have created index in SQL server 2000, but when i execute this query.
SELECT ProductName
FROM Products
WHERE CONTAINS(ProductName, ' "choc*" ')
... ProductName choc is exists in database but it does not show any record.. guide me why do't show the record.
Shabbir