|
Look Luke,
When you have one and only one product then exact and free search have the same result, Just one!
I looked and debugged your SP_searchProduct SQL scripts:
you are using FORMSOF(INFLECTIONAL, keyword) predicate which returns all variations of the keyword
WHERE CONTAINS(p.*,'FORMSOF(INFLECTIONAL, "%keyword%")')
The exact search predicate is LIKE and it be used this way :
WHERE p.productName LIKE '%keyword%'
You can make this as an option on search button to choose Exact or Free search but the default should be exact which returns less and more accurate result set.
Please remember your test site is not a valid and consistent database.
|