>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