>ALTER PROCEDURE [dbo].[sp_test2] >( >@LastSearch VARCHAR(50) = NULL, >@FirstSearch VARCHAR (50) = NULL, >@CASEID VARCHAR (10) = NULL, >@OFFREF VARCHAR (23) = NULL, >@MONTHDOB INT = NULL, >@DAYDOB INT = NULL, >@YEARDOB INT = NULL >) >AS > IF @CASEID IS NOT NULL > BEGIN > SELECT PATIENTDOB,* FROM case4 WHERE (LCASEID LIKE (@CASEID+'%')) > END > ELSE > IF @OFFREF IS NOT NULL > BEGIN > SELECT * FROM case4 WHERE (OFFICIALREF LIKE (@OFFREF+'%')) > END > ELSE > BEGIN > SELECT * FROM case4 WHERE > (patientlast LIKE ISNULL(@LastSearch,PATIENTLAST)+'%') AND > (patientfirst LIKE ISNULL(@FirstSearch,PATIENTFirst)+'%' ) AND > (MONTH(PATIENTDOB) = ISNULL(@MONTHDOB,MONTH(PATIENTDOB))) AND > (DAY(PATIENTDOB) = ISNULL(@DAYDOB,DAY(PATIENTDOB))) AND > (YEAR(PATIENTDOB) = ISNULL(@YEARDOB,YEAR(PATIENTDOB))) > end >Bill,
SELECT * FROM case4 WHERE (@LastSearch IS NULL OR patientlast LIKE @LastSearch+'%') ANDetc.