Please Refer the follwing Table and storeprocedure.
TABLE Name Behcode
ID behcode reseverd
1 1001 yes
2 1002 No
3 1003 yes
4 1004 No
And Below is the storeprocedure how to filter recodrs
-- EXEC SearchBehCodeDetails '','','no'
CREATE Procedure SearchBehCodeDetails
(
@id as Varchar(2)='',
@behcode as varchar(5)='',
@reserved as varchar(10)=''
)
AS
BEGIN
Declare @Sqlstr varchar(100)
Set @Sqlstr=' '
Declare @SqlWherestr varchar(100)
Set @SqlWherestr=' '
SET @Sqlstr= @Sqlstr+ ' SELECT * FROM BehCode '
IF (@id <> '')
BEGIN
SET @SqlWherestr = @SqlWherestr + ' id like ''%'+@id+'%'''
END
If (@behcode <> '')
BEGIN
SET @SqlWherestr = @SqlWherestr + ' behcode Like ''%'+@behcode+'%'''
END
IF (@reserved <> '')
BEGIN
SET @SqlWherestr = @SqlWherestr + ' reserved Like ''%'+@reserved+'%'''
END
IF (@id <> '' or @behcode <> ''or @reserved <> '')
BEGIN
SET @Sqlstr= @Sqlstr + ' Where ' + @SqlWherestr
END
EXEC (@Sqlstr)
End