SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_grpcls_classes]
    @group_code ais_code_short,
    @brand_code ais_code_short,
    @class_code ais_code_medium ='%'
AS 

	select	*
	from	grpcls_classes
	where	clsc_group_code = @group_code
	and		clsc_brand_code = @brand_code
	and		( @class_code = '%' or clsc_class_code = @class_code)


GO
