Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  How can I specify weight/importance by column?

Author  Topic  NickyJ Starting Member 46 Posts Posted - 2007-02-15 : 06:42:33 I have a Fulltext catalog containing 2 columns, say BookTitle and BookDescription, now when I search I want the results returned so that if the Word searched is in the BookTitle column then this is given a higher importance than if the word appeared in the other column BookDescription. Example Have 2 named books Book1 - The word SQL appears 3 times in Book Description field and appears once in BookTitle Book 2 - The word SQL appears twice in Book Description and twice in BookTitle. Results I'd want is that the Book2 would be at the top of my recordset as it appears twice in BookTitle and I want this to be of more importance. Can anyone advise.