Yes, I re-read the area in the book where I thought I read that, and see now that I was wrong. How would I handle that situation if I want to remove the filter? I need to filter by a certain BatchID, but I want the user to be able to select all batches.
>Yes OPENXML() and supporting sp_xml_* stored procedures are available in SQL 2000.
>
>>What a coincidence... I need to do this today too. Is this method available in SQL Server 2000? If I remember correctly, sp_xml_preparedocument is only a SQL 2005 procedure.
>>
>>>You can use XML to pass list of values into SP. See
Re: Sending a list from vfp Message #
829213