how to create Advanced seaarch in win forms ?

i use this code :

USE [Advanced_Search Test]

/****** Object: StoredProcedure [dbo].[SP_AdvanceSearch] Script Date: 31/08/2015 05:32:28 ?.? ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[SP_AdvanceSearch]

(

@Commodity nvarchar(50)= null,

@Exist int = null,

@Category nvarchar(50) = null,

@Warehouse nvarchar(50) = null

)

BEGIN

SELECT * FROM [dbo].[Full_View]

WHERE (

Commodity LIKE COALESCE(N''+@Commodity+'', Commodity)

AND Exist = COALESCE(@Exist, Exist)

AND Category LIKE COALESCE(N''+@Category+'', Category)

AND Warehouse LIKE COALESCE(N''+@Warehouse+'', Warehouse)

)

END

well done !

butt , how to get betwwen value1 and value2 ?