SQL Server - Stored Procedure Show Data

SP_Select.sql

CREATE PROCEDURE [Schema].[SP_Name] (@Param [DataType(Size)] = DEFAULT_VALUE)
AS
BEGIN
  -- Condition With Coalesce
  WHERE COALESCE(id, NULL) = COALESCE(@paramId, id, NULL) -- EQUALS
  AND COALESCE(name, '%') LIKE COALESCE('%' + @paramName + '%', name, '%')  -- LIKE
  AND (   -- DATE RANGE
    CONVERT(VARCHAR(10) , date, 111) >= CONVERT(VARCHAR(10) , @FromDate, 111)  AND 
    CONVERT(VARCHAR(10) , date, 111) <= CONVERT(VARCHAR(10) , @ToDate, 111)
  );
END 
GO