USE [UVIVIEW]
GO
/****** Object: UserDefinedFunction [dbo].[f_split] Script Date: 07/22/2022 09:27:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[f_split]
(
@c VARCHAR(2000) ,
@split VARCHAR(2)
)
RETURNS @t TABLE ( col VARCHAR(20) )
AS
BEGIN
WHILE ( CHARINDEX(@split, @c) <> 0 )
BEGIN
INSERT @t
( col
)
VALUES ( SUBSTRING(@c, 1, CHARINDEX(@split, @c) - 1)
);
SET @c = STUFF(@c, 1, CHARINDEX(@split, @c), '');
END;
INSERT @t
( col )
VALUES ( @c );
RETURN;
END;
GO