create function func_reconbineStr(@str varchar(10))
returns varchar(20)
as
begin
declare @strInt int
declare @strArg varchar(20)=''
declare @charInt int=0
set @strInt=charindex('.',@str,1)
while(@strInt>0)
begin
set @charInt=@strInt-1
if(@charInt<0)
set @charInt=0
set @strArg=@strArg+right('00'+substring(@str,1,@charInt),2)+'.'
set @str=substring(@str,@strInt+1,len(@str))
set @strInt=charindex('.',@str,1)
end
set @strArg=@strArg+right('00'+substring(@str,1,len(@str)),2)+'.'
return @strArg
end
如下:
1.0
1.1
1.10
1.11