Split String Into Fixed Length Pieces in SQL

Rasel Ahmed answered on September 28, 2022 Popularity 3/10 Helpfulness 1/10

answer Split String Into Fixed Length Pieces in SQL

Split String Into Fixed Length Pieces in SQL

Comment

/*
	
	select * from dbo.fn_SplitIntoFixedLengthString('SQL split string function', 2)
*/

create function dbo.fn_SplitIntoFixedLengthString (
 @string nvarchar(max),
 @stringlength int
) returns @list table (
 string nvarchar(max)
)
as

begin
-- sql function begins
if len(@string) > 0 and @stringlength > 0
begin

 declare @i int -- character index
 set @i = 1

 while @i <= len(@string)
 begin
  insert into @list (string) select SUBSTRING(@string,@i,@stringlength)
  set @i = @i + @stringlength
 end

end

return
-- sql function ends
end

Popularity 3/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: fixed sql string

Link to this answer
Share Copy Link

Contributed on Sep 28 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Split String Into Fixed Length Pieces in SQL

Contents

More Related Answers

Split String Into Fixed Length Pieces in SQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.