-- ================================================
-- Template generated from Template Explorer using:
-- Create Scalar Function (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE OR ALTER FUNCTION fn_array (@lista varchar(100), @separador char(1), @linha int)  
RETURNS varchar(100)  
AS  
BEGIN  

	RETURN (
		SELECT top 1
			b.valor
		FROM (
			SELECT
				ROW_NUMBER() over(order by tab) as linha,
				a.valor
			FROM(
				SELECT
					1 as tab,
					value as valor
				FROM STRING_SPLIT(@lista, @separador)
			) a
		) b where b.linha = @linha
	);

END
GO

