USE [site_fuchs]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_fn_link_csv]    Script Date: 02.12.2020 21:05:05 ******/
DROP FUNCTION [dbo].[ocms_fn_link_csv]
GO
/****** Object:  UserDefinedFunction [dbo].[ocms_fn_link_csv]    Script Date: 02.12.2020 21:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[ocms_fn_link_csv]
(
	@inp1 varchar(4000)
	,@inp2 varchar(4000)
)
RETURNS varchar(4000)
AS
BEGIN
	DECLARE @RET varchar(4000) = ISNULL(@inp1, '')
								+ CASE WHEN ISNULL(@inp1, '') <> '' AND ISNULL(@inp2, '') <> '' THEN ',' ELSE '' END
								+ ISNULL(@inp2, ''); 
								 

	RETURN @RET;

END
GO
ALTER AUTHORIZATION ON [dbo].[ocms_fn_link_csv] TO  SCHEMA OWNER 
GO