Problem in executing the Contains query - TechRepublic
General discussion
September 1, 2004 at 04:02 AM
shabirmaher

Problem in executing the Contains query

by shabirmaher . Updated 21 years, 10 months ago

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

This discussion is locked

All Comments