declare @hhh varchar(100)
set @hhh='123.12.12.12.22.2412'
select substring(@hhh,1, len(@hhh)-CHARINDEX ('.',REVERSE(@hhh),1 ) )
set @hhh='123.12.12.12.22.2412'
select substring(@hhh,1, len(@hhh)-CHARINDEX ('.',REVERSE(@hhh),1 ) )
set @str = '1.2.3.4'
select substring(@str, 1, len(@str) - charindex('.', reverse(@str)))