you can write it as follows
BEGIN
DECLARE @CAMP VARCHAR(2)
DECLARE @TYPE VARCHAR(10)
SET @TYPE='';
SET @CAMP=''
DECLARE @QRY NVARCHAR(300)
SET @QRY='SELECT * FROM [dbo].[LIBMAST ] WHERE (1=1)';
IF(@CAMP<>'')
BEGIN
SET @QRY=@QRY+' AND CAMPUS='''+@CAMP + '''';
END
IF(@TYPE<>'')
BEGIN
SET @QRY=@QRY + ' AND TYPE= '''+@TYPE + '''';
END
EXEC SP_ExecuteSql @QRY;
END
Just use (1=1) always true trick.