I have an sp in SQL server 7 that has 5 parameters. Users can select one or more values for each parameter. So, one parameter could have 1 value while another may have 10. What is the easiest way to send those parameter values from an ASP page to the sp. Can the paramater in the sp be an array. If yes how do I do it? Any help would be appreciated.