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