This is a question I am sure some of you would have experiences and answers. please help.

I am trying to develop a VB search interface for a SQL7 database. The problem is that users may have one to many fields to search. What is the effecient way (in coding and running) to achieve it???

The idea way of course is to pass a 2D array through ADO into a Stored Procedure and hopefully there is a way to handle array parameters in the procedure (in T-SQL language).

But I am not sure at all I can do that. My goal is to do all selection Hard-Coding in Stored Procedure. Can someone please give me some advices? Thanks a lot.