Its Sunday in India and must be Saturday in US I never expected the answer this fast on holiday.

>>Can we pass variable number of parameters to sql stored procedures
>>like we pass to vfp functions. Then process them depending on the
>>number of parameters passed.
>>-----------------------------------
>>Rajesh Halyal
>
>Yes, you can have optional parameters in SP and you would check them for IS NULL.
>
>See http://sqlserver2000.databases.aspfaq.com/can-i-have-optional-parameters-to-my-stored-procedures.html