I have written a search in asp which allows the user to input keywords to find results that are held in a database.<BR>This works fine; it pages through the results etc fine.<BR>BUT<BR>The same result is often returned 6 or so times, because of more than one keyword being present for that result.<BR>Is there any way to remove duplicates from the results before they are paged.<BR><BR>Also: Can I get a total number of results, rather than a total number of pages?<BR><BR>Also2: Can I rank the results by relevance (by the number of times that they matched a keyword), also before thay are paged...<BR>?<BR><BR>Any comments/help would be helpful.<BR>