Search Condition

Hi This is madhavi

am working with a project with ASP.NET Using VB.NET..

i have requirement that i have to provide the result based on search condition....

First : For Serach i have to search based on given CITY and CATEGORY....

 

      For this i have written a StoredProcedure like:

******************************************************************************************************************

         Create PROCEDURE YellowPages_Search
(
@city nvarchar(50),
@SearchWord nvarchar(200),
@Name varchar(50) OUTPUT,
@CompanyName varchar(50) OUTPUT,
@Address varchar(1000) OUTPUT,
@PhoneNo varchar(50) OUTPUT,
@MobileNo varchar(50) OUTPUT,
@Fax varchar(50) OUTPUT,
@Email varchar(50) OUTPUT,
@WebSite varchar(50) OUTPUT
)
AS

declare @sql nvarchar(1000)
set @sql='select * from YellowPages_Userdetails where city='''+@city + '''and (category like ''%' + @SearchWord + '%'' or subcategory  like ''%' + @SearchWord + '%'') '

exec(@sql)

GO

*************************************************************************************************************************************************************************

Now  i want to extend this search condition for LOCATION and SUBCATEGORY

 means my search condition should include CITY , LOCATION , CATEGORY and SUBCATEGORY

(here the location and subcategory may be given or may not be given)

so please help me out

Thanks in Advance,

Madhavi