I have asp.net C# web application I want to search jobvacancy details using jobrole.
if user did not select any value I want to select all the details including null values.
this Jobvacancy table has JobRole feild and it allow to insert null values,
this is my stored procedure
CREATE PROCEDURE JobVacancy ( @JobRole varchar (50) ) as Select NoOfVacancies,JobRole from JobVacancy where JobRole LIKE @JobRole + '%'
when I use @JobRole value as '%' then if JobRole feild has null value it did not select.
but I want to select all the values including null values. how can I do this?