I am trying to create a questions and answers type website which will need people to be able to search the previously asked questions/ answers and come back with ranked links to the questions. For the search I need to search 3 fields, 2 in the Question table and 1 in the Answers A single question and all its seperate answers should be considered one item for the purposes of ranking I guess that a simple word count is the easiest way to rank but how to get the word count and combin up the values for the different search words, tables, columns etc is giving me headaches. The site is just a personal hobby for me so will be hosted on a shared MS SQL database which doesnt allow full text indexing. It happens to be written in .Net however SQL is SQL no matter what the language used to construct it so dont let that put you off Any suggestions or pointers would be very much appreciated.