Stored procedure required

[leo2507]

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 GetMemberlocation
@Name varchar(100),
@Address1 varchar(500),
@Address2 varchar(500),
@City varchar(100),
@State int,
@Phone varchar(100),
@Fax varchar(100),
@Zip varchar(100)

AS
BEGIN
SELECT
m.[Name],
m.Address1,
m.Address2,
m.City,
s.State,
m.Phone,
m.Fax,
m.Zip
FROM
Memberlocation m,
State s
where
s.Id=m.state and
(
m.[Name]like @Name and
m.Address1 like @Address1 and
m.Address2 like @Address2 and
m.City like @City and
m.phone like @Phone and
m.Fax like @Fax and
m.Zip=@Zip

)

END


Pls guide where m i wrong ???
Thnx,
Leo

[debasisdas]

As you have posted a question in the articles section it is being moved to SQL Server forum.

MODERATOR.