Hey guys, New to sql, even newer to sql2005 hehe, created and run the following query:SELECT DISTINCT tblFund.Fund_id, tblFund.Fund_name, tblFund.Fund_short_name, tblFund.Fund_Insert_date, tblFund_Name_Match.Fund_reported_nameFROM tblFund INNER JOIN tblFund_Name_Match ON tblFund.Fund_id = tblFund_Name_Match.Fund_id
Now I wish to compare the text in the fields Fund_name and Fund_reported_name, ideally with some kind of scale- where 1 means they are the same and 5 means they are totally different etc.Some initial research led me to Full Text Search, however, when right clicking a table this option was greyed out. I thought perhaps it was not installed, I typed the following in: selectfulltextserviceproperty('isFulltextInstalled')Which gave me the result 1- indicating it is indeed installed. Is this the right thing I am tying to do? Are there other options?Thanks guys!