create function UserLastInexOf(@split char(1),@context nvarchar(500))
returns int
as
begin
declare @lastindex int
select @lastindex=len(@context)-charindex(@split,reverse(@context))+1
return @lastindex
end
我画一副图大家就都明白了create function UserLastInexOf(@split char(1),@context nvarchar(500))returns intas begin declare @lastindex int select @lastindex=len(@context)-charindex(@split,reverse(@context))