Brian, On Mon, 28 Feb 2005 16:32:09 -0500, Brian Cummiskey <Brian at hondaswap.com> wrote: > How can i adjust the query so that it is inclusive of all, but not > overkill once the database starts to grow (and it will by the hundreds > per day)? You essentially would ideally be able to score each search result. I don't know what database you are using, and even if you did, all I would really be able to suggest is full-text searching, which isn't *exactly* what you're asking for (although it might work for you): http://www.google.com/search?q=full+text+%7Esearching+sql+server -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.