用反转函数reverse和函数charindex获取IP地址的最后一段

declare @str varchar(50)
set @str = reverse(substring(reverse('192.168.1.100'),1,charindex('.',reverse('192.168.1.100')) - 1))

select @str