Home Forums SQL Server 2005 T-SQL (SS2K5) Select just three octets from IP number RE: Select just three octets from IP number
Hari.Sharma
SSCertifiable
Points: 6904
More actions
June 30, 2008 at 8:29 am
#836155
DECLARE @t VARCHAR(15)
SET @t = '10.0.123.77'
SELECT PARSENAME(@t,4)+'.'+PARSENAME(@t,3)+'.'+PARSENAME(@t,2)