Home Forums SQL Server 2005 T-SQL (SS2K5) Select just three octets from IP number RE: Select just three octets from IP number

  • June 30, 2008 at 8:32 am

    #836158

    Alternatively u can do:

    DECLARE @t VARCHAR(15)

    SET @t = '10.0.123.77'

    SELECT Left(@t,Len(@t)-CHARINDEX('.',Reverse(@t)))

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers