title: What is the SQL Server equivalent of INET_ATON
body: <p>As the question says what is the SQL Server equivalent of <code>INET_ATON</code> from mySql. The reason I need this is because i imported a IP data base from <a href="http://ipinfodb.com/ip_database.php" rel="nofollow noreferrer">http://ipinfodb.com/ip_database.php</a> into SQL Server 2005 and would like to query the table now. But based on their examples I am not sure how to do that.</p>
  
  <blockquote>
    <p><a href="http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton" rel="nofollow noreferrer">INET_ATON(expr)</a></p>
    
    <p>Given the dotted-quad representation
    of a network address as a string,
    returns an integer that represents the
    numeric value of the address.
    Addresses may be 4- or 8-byte
    addresses.</p>
  
  <pre><code>mysql&gt; SELECT INET_ATON('209.207.224.40');
          -&gt; 3520061480
  </code></pre>
  </blockquote>