Hi,
I am using customized search in MOSS using FullText sql query. In my custom search webpart I have to provide advanced search functionality.
The user will choose the values from dropdownlists and hit the search.
I have tried FullTextSQl query with the contains clause as well as Like :
Contains(<column_Name>, '<search_input>')
and also
<search_column> like '%<search_input>%'
But for the same search input i got different no.of results. Is there a specific reason behind this?
For improved Performance and better ranking of the search results which one is prefferred to use.
Thanks in Advance for any valuable input.