i think what you need is to define default values for all parms and if value is default you wont be apperaing thet particular filter. for example let default for parameters be null then you can do likeCREATE PROCEDURE ReportSelect(@SenderID int = NULL,@EmployerID int =NULL,@ReportPeriod varchar(20)=NULL,@ReportType varchar(50)=NULL)ASSELECT ReportID, ReportType, ReportPeriod, EmployerNameFROM Reports WHERE SenderID = COALESCE(@SenderID,SenderID) AND EmployerID = COALESCE(@EmployerID,EmployerID) AND ReportPeriod = COALESCE(@ReportPeriod,ReportPeriod)AND ReportType = COALESCE(@ReportType,ReportType )