USE [CMS]
GO
/****** Object: UserDefinedFunction [dbo].[concat] Script Date: 2021/10/18 13:37:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[concat]
(
@REF_1 varchar(max),
@REF_2 varchar(max)
)
RETURNS VARCHAR(MAX)
AS
BEGIN
DECLARE @REF_1_DO VARCHAR(max);
DECLARE @REF_2_DO VARCHAR(max);
IF @REF_1 IS NULL
BEGIN
SET @REF_1_DO = ''
END
ELSE
BEGIN
SET @REF_1_DO =@REF_1
END
IF @REF_2 IS NULL
BEGIN
SET @REF_2_DO = ''
END
ELSE
BEGIN
SET @REF_2_DO =@REF_2
END
RETURN @REF_1_DO+@REF_2_DO
END
GO
