

Forum Newbie
Group: General Forum Members
Last Login: Wednesday, December 3, 2008 6:42 AM
Points: 7,
Visits: 27


I need to create a function to select just 3 octets from a column (ip_number). I paste below the select that I did, but it is very large. anyone have any idea so that I can reduce this select?
 I want to identify only three octets, the IP number
declare @x varchar(20) select @x = '10.0.42.162' select @x = '10.0.200.120'
select @x Ip, substring(@x,1,len(substring(@x,1,charindex('.', @x ))))+ substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, len(substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, charindex('.', substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)) )))) + substring(SUBSTRING(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x ))))+ substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, len(substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, charindex('.', substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)) )))))+1, LEN(@x)),1,charindex('.', SUBSTRING(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x ))))+ substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, len(substring(substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)),1, charindex('.', substring(@x,len(substring(@x,1,len(substring(@x,1,charindex('.', @x )))))+1,len(@x)) )))))+1, LEN(@x)) )) rede




SSCrazy
Group: General Forum Members
Last Login: Thursday, April 28, 2016 12:16 PM
Points: 2,764,
Visits: 4,064


DECLARE @t VARCHAR(15)
SET @t = '111.222.333.444'
SELECT PARSENAME(@t,4),PARSENAME(@t,3),PARSENAME(@t,2)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg




Ten Centuries
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330,
Visits: 455





Ten Centuries
Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330,
Visits: 455





Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 25, 2010 6:54 AM
Points: 1,
Visits: 0


This is great information, thanks!



