declare @str varchar(50)
set @str='910*122*16'
--set @str='1500*150*6'

select reverse(substring(reverse(@str),1,charindex('*',reverse(@str))-1)) 


--------------------------------------------------
16

(1 行受影响)