MSSQL FREETEXTTABLE SEARCH - how to specify occurance of keywords from "atleast one keyword exists" to "all keywords exist"

See more:

SQL-Server

hi all,

in my website (mssql db) i have a master search and filter search. in master search, i use freetexttable in my stored proc to search if keywords entered by the user is found in any of the columns of my table and it works fine. however when it comes to filter search which is not yet implemented, freetexttable creates a havoc. in filter search i want to filter the master search's results based on new keywords entered by the user. on using freetexttable, i am getting more rows in the result than master search. if anybody can tell me a way to implement an "and" in a freetexttable query, my problem will be solved.

thanks & regards, AR