• No need to cast either

    alter function dbo.ConvertIp2Num(@ip varchar(15))

    returns bigint

    as

    begin

    return16777216.0 * parsename(@ip, 4)

    + 65536 * parsename(@ip, 3)

    + 256 * parsename(@ip, 2)

    + 1 * parsename(@ip, 1)

    end


    N 56°04'39.16"
    E 12°55'05.25"