General discussion

  • Creator
    Topic
  • #2289482

    Problem in executing the Contains query

    Locked

    by shabirmaher ·

    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

All Comments