>>>>>>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.
>
>I was there looking for something else, and it appears that you will want to look at the 2/25 entry.

Hi Mike

as this is against a VFP back end I don't think Kevins solution would be so straightforward.

Nick