Ok, now i need to execute the same query and give the user the option of bringing back rows with all of the words(in any order) or any of the...

Didn't realize you could 'execute' a string...now i know. Thanks guys!!!

allrighty, yall are just rubbing it in now

wow, i am embarrassed. i guess i need to change my user name. :ermm:

Thanks peso... I am looking for different solutions...unfortunately i am not a T-SQL wiz and was hoping for something a little more straight forward; e.g., is there an...