Thursday, April 28, 2011

Full-text search with wildcard

I have a table with full text search enabled. But I can't get query the table using wildcard.

select * from products where contains(Description, 'Computer') returns rows with the word "Computer"

select * from products where contains(Description, 'Compute*') [replace "r" with "*"] returns nothing

What's going on?

From stackoverflow
  • Assuming SQL Server, add double quotes around the wildcarded expression like so

    SELECT * 
    FROM products 
    WHERE contains(Description, '"Compute*"')
    

0 comments:

Post a Comment