C11/System/ARI/SQL/schema/GC_ETL_ARI/functions/to_varchar100.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE FUNCTION [dbo].[to_varchar100] (@d varchar(255))
RETURNS varchar(100)
with execute as CALLER
    AS
    BEGIN
		declare @to_varchar varchar(100);
        set @d = replace(@d, '"', '');
		set @to_varchar = left(@d, 100);
			
		return (@to_varchar);
    END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO