Post reply

Wild card search on Full text index

  • March 5, 2009 at 5:58 am

    #131432

    I have created full text index on my product catalog.

    when i search for word "Pendant" it gives me result. but when i passed it as "endant" then it doesnt return any rows?

  • March 5, 2009 at 11:05 pm

    #954653

    Full text indexing adds another dimension to your database so to speak. To use the full text indexes you have to use the keyword CONTAINS in your SELECT statement such as:

    SELECT *

    FROM Product

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

  • March 7, 2009 at 3:19 am

    #955432

    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 it returns me 84 rows.

    SELECT *

    FROM Item

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

    i also tryi this with FreeText but it is not working. 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply