Create Procedure Nom_procedure @parametre1 numeric, @parametre2 varchar(255), @parametre3 varchar(255) As if (@parametre1 <> 0) begin if (@parametre2 is not null) begin if (@parametre3 is not null) select * from MATABLE where Macolonne = @parametre1 and Macolonne like '@parametre2' and Macolonne like '@parametre3' else select * from MATABLE where Macolonne = @parametre1 and Macolonne like '@parametre2' end else begin if (@parametre3 is not null) select * from MATABLE where Macolonne = @parametre1 and Macolonne like '@parametre3' else select * from MATABLE where Macolonne = @parametre1 end end else begin if (@parametre2 is not null) begin if (@parametre3 is not null) select * from MATABLE where Macolonne like '@parametre2' and Macolonne like '@parametre3' else select * from MATABLE where Macolonne like '@parametre2' end else begin if (@parametre3 is not null) select * from MATABLE where Macolonne like '@parametre3' else select * from MATABLE end end GO