Maybe if i ask a more specific question, i can get a better response.

How do i write this where statement to make use of both select statements ?

Declare @Drugs xml,...

Sean i guess i have many problems, the main one is i hit a wall. First can i join the xml being passed in the SP to the database ?...

I am sorry it is actually 2 columns one with an id and one with a string

yes they will vary but alot of them stick to the pattern i mentioned

but...