字符串分段

 1 ALTER function [dbo].[字符串分段](@STR varchar(80),@x int,@jgf varchar(10))
 2 returns varchar(100)
 3 begin
 4 set @str=REPLACE(@str,' ','')
 5 Declare @length int=len(@str)
 6 Declare @index int=1
 7 Declare @yhk varchar(100)=''
 8 while @index<=@length
 9 begin
10 set @yhk=iif(@yhk='',SUBSTRING(@str,@index,@x),@yhk+@jgf+SUBSTRING(@str,@index,@x))
11 set @index=@index+@x
12 end
13 return @yhk
14 end