use Patient_Data
go

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

Create FUNCTION [dbo].[Address](
@HouseStreet as Varchar(50),
@Barangay as Varchar(50),
@CityMunicipalityPSGC as Varchar(50)
)RETURNS Varchar(150) AS  
BEGIN 
  RETURN ISNULL(@HouseStreet,'') + ', ' + ISNULL(@Barangay,'') + ' ' + LEFT(ISNULL(@CityMunicipalityPSGC,''),1)
END