SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_cts_chains]
	@chain_code AS ais_code_short  = '%' 
AS
BEGIN
	SET NOCOUNT ON

	SELECT	*
	FROM cts_chains
	WHERE @chain_code = '%' OR ctsch_chain_code = @chain_code
END
GO
