>>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