<div>
You could use some of the many freetext searches provided within SQL. Each of these will provide a Rank or a Weight against the search. This would give you your relevance.
</div>


You could use some of the many freetext searches provided within SQL. Each of these will provide a Rank or a Weight against the search. This would give you your relevance.

<div>
Hi Alfa,<br />
<br />
Thanks for your prompt response - not entirely sure what you mean? &nbsp;Could you expand on this please? &nbsp;Are these 'free text' searches inherent in SQL or do you mean SQL Server?<br />
<br />
Bob
</div>


Hi Alfa,

Thanks for your prompt response - not entirely sure what you mean?  Could you expand on this please?  Are these 'free text' searches inherent in SQL or do you mean SQL Server?

Bob

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I am developing a website that enables visitors to search through a database of books - the search will query the author, title and keyword field. &nbsp;As it is search mutiple fields, it would be useful to be able to rank the results by 'relevance' as do some search engines.<br />
<br />
Does anyone know where I can get some good sample code for doing this?<br />
<br />
Thanks<br />
<br />
Bob
</div>
</div>


Hi all,

I am developing a website that enables visitors to search through a database of books - the search will query the author, title and keyword field.  As it is search mutiple fields, it would be useful to be able to rank the results by 'relevance' as do some search engines.

Does anyone know where I can get some good sample code for doing this?

Thanks

Bob

Simple Search result ranking algorithm for ASP / SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.