SQL Server Performance

Looking for function to convert ip/mac address to integer and vise versa

Discussion in 'General Developer Questions' started by RaymondXie, Sep 10, 2007.

  1. RaymondXie New Member

    1. Hello,

      Just wondering if anyone has function for converting IPv4 address and Mac address to integer? and vise versa? Thanks.
    RaymondXie, Sep 10, 2007
    #2

  2. Luis Martin Moderator

    http://www.justin-cook.com/wp/2006/11/28/convert-an-ip-address-to-ip-number-with-php-asp-c-and-vbnet/
    Luis Martin, Sep 10, 2007
    #3

  3. RaymondXie New Member

    Hi Luis,
    Thanks for your help. Do you happen to also have one for Mac address?
    RaymondXie, Sep 11, 2007
    #4

  4. Luis Martin Moderator

    Sorry, I can't find that.
    Luis Martin, Sep 11, 2007
    #5

  5. ranjitjain New Member

    I have used following method or way to convert ip to number
    declare
    @iptonum varchar(15),@ip varchar(15)SET @ip='10.5.25.255'select parsename(@ip,4)+right(('00'+parsename(@ip,3)),3)+right(('00'+parsename(@ip,2)),3)
    +right((
    '00'+parsename(@ip,1)),3)
    ranjitjain, Sep 12, 2007
    #6

  6. RaymondXie New Member

    Yes, this one is the simplest one, I saw that on other forum. Do you do Mac too? And how about vise versa?
    Thanks.
    RaymondXie, Sep 12, 2007
    #7

Share This Page