字符串分段

ALTER function [dbo].[字符串分段](@STR varchar(80),@x int,@jgf varchar(10))
returns varchar(100)
begin
set @str=REPLACE(@str,' ','')
Declare @length int=len(@str)
Declare @index int=1
Declare @yhk varchar(100)=''
while @index<=@length
begin
set @yhk=iif(@yhk='',SUBSTRING(@str,@index,@x),@yhk+@jgf+SUBSTRING(@str,@index,@x))
set @index=@index+@x
end
return @yhk
end