How to use like Operator in Sql Stored procedure?

In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here I used  nullable parameter (IsNull) and search the product using Like keyword.

Example: 

CREATE PROCEDURE SearchProduct @Name VARCHAR(250)
AS    
SELECT * FROM [Product] 
WHERE Name like '%'+IsNull(@Name,Name)+'%'

here i created a stored procedure name called SearchProduct for searching the product using Like keyword with nullable parameter.

Output:  I searched for mobile products,

EXEC ProductList 'mobile'