SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[p_grid_nm_professions]
    @prof_code ais_code_short = '%'
AS 

select *
from nm_professions
where	@prof_code = '%' or nmprof_prof_code = @prof_code






GO
