USE [CMS]
GO
/****** Object: UserDefinedFunction [dbo].[concat] Script Date: 2021/10/18 13:37:59 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
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
SET @REF_1_DO = ''
END
ELSE
SET @REF_1_DO =@REF_1
IF @REF_2 IS NULL
SET @REF_2_DO = ''
SET @REF_2_DO =@REF_2
RETURN @REF_1_DO+@REF_2_DO
