SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_nm_umr]
	@umr_code AS ais_code_long  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM nm_umr
	WHERE @umr_code = '%' OR umr_umr_code = @umr_code
END

GO
