>>>>>>>>>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
>>
>>I didn't realize that. Let us know what kind of solution you went with.
>
>My fault.I should have posted a fuller description of my need.
>
>Kevins is interesting and my be relevant if I could shift to SQL Server

Maybe you could find answers in the VFP forum? I think this is more of a database question than a development tool question, at least from a .NET/SQL Server POV.