Web Hosting Info

Search:

featured partner

The IP to Country Database
  Forum Topics : Support / Converting IP address to A.B.C.D format in SQL 2000
Submitted by dhiraj on Thu, 10/16/2003 - 18:26.
Is there a funcation or formula whihc I can use to convert the IPAdress to A.B.C.D format in Microsoft SQL 2000.

Thanks,
Dhiraj
» login or register to post comments | previous forum topic | next forum topic | 898 reads
Comment viewing options:
Select your preferred way to display the comments and click 'Save settings' to submit your changes.
This might help?
Posted by strummer on Sat, 10/18/2003 - 07:09.
I dont know Microsoft SQL 2000 and what queries it can embed, if anything :-? but assuming this might be vb related these links might be useful:

Convert Dotted Quad IP Address to Long IP Address and Vice Versa
Convert an IP address to a Long Integer for API Calls
Convert LongIP Address to StringIP Address
Convert StringIP Address to LongIP Address

from using this search on google:
convert long ip address

----------
Q. Should I put a witty comment below my post?
A. No.
» login or register to post comments
Found code listing
Posted by rdstanley on Fri, 09/24/2004 - 01:08.
Found a listing for code creates a function that converts ip from string format to long format

http://www.sqlservercentral.com/scripts/contributions/943.asp
» login or register to post comments