
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_pol_subclasses]
    @class_code ais_code_short,
    @subclass_code ais_code_short = '%'
AS 

select	*
from	pol_subclasses
where	scls_class_code = @class_code
AND		(
			@subclass_code = '%' OR scls_subclass_code = @subclass_code
		)

GO
