复制create function fn_GetLastCharIndex(@Chars varchar(1000),数据@Char varchar(10)) returns varchar(1000) begin declare @i int set @i=CharIndex(@Char,@Chars) while(@i>0) begin set @Chars=Substring(@Chars,@i+1,len(@Chars)) set @i=CharIndex(@Char,@Chars) end return @Chars end 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.