USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_BF_SearchLabSection]    Script Date: 11/21/2017 15:34:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[Lab_BF_SearchLabSection]
AS

select	Isnull(LabSectionId,'') as [Code],
		IsNull(LabSection,'') as [Section],
		IsNull(SectionHead,'') as [SectionHead],
		IsNull(Active,0) as [Active], 
		cast(IsNull(WithVerifier,'0') as int) as [WithVerifier],
		ISNULL(Pathologist,'') as [Pathologist],
		ISNULL(PathologistId,'') as [PathologistId]
from BUILD_FILE..tbCoLabSection
Order by LabSection