I am doing a contains search on the columns on the database. I have already run separate queries to confirm text1, text2 and text3 are on the database. then I have the following query :
select * from Item I where contains(i.*,'text1') and contains(i.*,'text2') and contains(i.*,'text3')
how do I get the results with ranking from Sql server on the matches?