Remove Delimiter And Get Strings in Separate Columns

Remove Delimiter And Get Strings in Separate Columns :

CREATE FUNCTION FN_SeparateDelimeterFromString (@string NVARCHAR(MAX),@separator NCHAR(1))
RETURNS @SeparatedStrings TABLE (string NVARCHAR(MAX))
AS
BEGIN
   DECLARE @position int
   SET @position = 1
   SET @string = @string + @separator
   WHILE charindex(@separator,@string,@position) <> 0
      BEGIN
         INSERT into @SeparatedStrings
         SELECT substring(@string, @position, charindex(@separator,@string,@position) - @position)
         SET @position = charindex(@separator,@string,@position) + 1
      END
     RETURN
END
Declare @Strings varchar(max)

Set @Strings='1,2,3,4,5,6,7'

select string from FN_SeparateDelimeterFromString(@Strings,',')

select string from FN_SeparateDelimeterFromString('N,I,T,I,S,H,,K,U,M,A,R',',')

Ebook Download
View all

My Ideas

Read by 2 people
Download Now!
Learn
View all