I'm using MS SQL Server Advanced Features.
I've applied Full Text Index to my products table (e-commerce site).
I'm using this select statement as a test for my product search box.
SELECT * FROM Products join ContainsTable(Products, product, '"search product"') as FT
Order By RANK ASC
The results i get arn't really what i was expecting.
If i type in a search such as cb300 i get the correct product returned, cb300 professional checkbox.
However, if i type in cb300 checkbox (missing out the word professional), i don't get anything returned.
It seems i only get the correct return if the search string is in a logical order.
I'm using MS SQL 2008 and Classic ASP.
Any ideas on how to make the search more intelligent?
If you look at the very bottom of Contains, there are several of them, and I even presented a piece of code in my previous post which should solve the issue you presented in your original post. What is it that you don't get to work?