>>>>Hi
>>>>
>>>>In ASP many years ago if I had an SQL query where I had multiple parameters not all of which may be filled in I created the SQL in code.
>>>>
>>>>In the same situation in ASP .NET what are my options. I don't seem to be able to find anything where I may have a flexible number of query parameters. Am I still having to build up my query in code.
>>>>
>>>>Any thoughts / examples.
>>>>
>>>>Thanks
>>>
>>>Can you pass in an XML string as a parm, convert it to a temporary table, and do an INNER JOIN? Kevin G. was an expert on this subject - maybe check his blog?
>>
>>Cheers Mike.
>>
>>What address was Kevins blog ?
>>
>>I'll take a look though that seems like a bit of work for a common requirement.
>>
>>Nick
>
>If we are thinking the same thing, it's not really that much work after you get it figured out the first time.
>
>www.commongroundsolutions.net - click on the blog link.

Thanks Mike I'll take a look.