Hello
Got me a question. I have a sproc that I am using to return a result set with a changing where clause.
If a value coming into the sproc is null then I don't want to include that value into my where clause.
In thread183-393720 I found that I could do this using a string a building the entire select depending on what incoming values are available.
Is there another way of doing this? If so what advantages/disadvantages do the methods have over each other?
Thanks for your answers/comments That'l do donkey, that'l do
![[bravo]](/data/assets/smilies/bravo.gif "[bravo] [bravo]")
Mark
If you are unsure of forum etiquette check here faq796-2540
Got me a question. I have a sproc that I am using to return a result set with a changing where clause.
If a value coming into the sproc is null then I don't want to include that value into my where clause.
In thread183-393720 I found that I could do this using a string a building the entire select depending on what incoming values are available.
Is there another way of doing this? If so what advantages/disadvantages do the methods have over each other?
Thanks for your answers/comments That'l do donkey, that'l do
MarkIf you are unsure of forum etiquette check here faq796-2540