SQL Server:如何查找紧跟在最后一个子字符串之后、下一个逗号之前的子字符串

DECLARE @inputString VARCHAR(100) = 'abc,def,ghi,jkl,mno'
DECLARE @lastSubstring VARCHAR(100)
DECLARE @nextCommaIndex INT

-- 找到最后一个逗号的位置
SET @nextCommaIndex = CHARINDEX(',', REVERSE(@inputString))

-- 如果存在逗号，则截取最后一个子字符串
IF @nextCommaIndex > 0
    SET @lastSubstring = RIGHT(@inputString, @nextCommaIndex - 1)
ELSE
    SET @lastSubstring = @inputString

SELECT @lastSubstring AS LastSubstring