I m using ASP.NET with C# to generate a search page in which the user is required to enter atleast one field among Name, Address, City, Zip and search for the members stored in database.. He might enter all fields at a time as well.i.e. the filtering would become more precise if the no. of fields he entered is more.
What "where" condition should i use?
My WRONG procedure is as follows:

Create PROCEDURE GetMemberlocati on...