CREATEFUNCTION dbo.lastindexof (@stringValueasnvarchar(1000), @stringSearchasnvarchar(1000), @startPositionasint=0) returnsint AS BEGIN DECLARE@lastindexint SET@lastindex=@startPosition DECLARE@tempindexint while (1=1) begin SET@tempindex=charindex(@stringSearch, @stringValue, @lastindex+1) if (@tempindex=0) break SET@lastindex=@tempindex end RETURN(@lastindex) END