Hey folks, I have found an answer to my question. If a parameter is null, just don't pass it ! All you have to do, is to put a default value in the parameter of your stored procedure. Before calling you procedure and putting the variable value in the parameter collection, just check the value and if it's wrong, then ton put any argument in your parameter !!!

Ex:
sp_Example
@ExampleID int, @Name varchar(25), @LastName varchar(25) = NULL
as
Select...

Eric Trembaly