Is it possible to create new column in the DB where you store the IPs with zero padded values that oyu use just for sort. So when you insert the values into the DB, you insert two values. One with the real value and one with the padded value that would look something like:

<code>
<cfset ipaddy = "10.98.128.2">

<cfset ipArray = ArrayNew(1)>
<cfset ipArray[1] = ListGetAt(ipaddy, 1, ".")>
<cfset ipArray[2] = ListGetAt(ipaddy, 2, ".")>
<cfset ipArray[3] = ListGetAt(ipaddy, 3, ".")>
<cfset ipArray[4] = ListGetAt(ipaddy, 4, ".")>

<cfoutput>
   #NumberFormat(ipArray[1],'000')#.#NumberFormat(ipArray[2],'000')#.#NumberFormat(ipArray[3],'000')#.#NumberFormat(ipArray[4],'000')#
</cfoutput>
</code>

I hope my code above shows up correctly.

I've never tried had this problem for some reason (probably because I use jQuery to sort tables, and it'll recognize an IP address automatically).

So I thought I'd come up with the most long rounded way possible. This involves converting the IP Address to a decimal string, and uses 2 UDFs.. quite silly really. I'm sure there's a solution in one line...

Source code here:

http://www.oxalto.co.uk/demos/sortip.cfm

First I would look here:
http://office.microsoft.com/en-us/access/HP0116461...
AND here:
http://www.dbforums.com/showthread.php?t=585462

Based on those you could probably come up with a purely SQL way of getting the sort you want.

I would add 4 columns to your DB for each octal of the IP and then sort them accordingly.

Thanks for the suggestions. I was actually able to solve this with a MySQL Function. I converted from the Internet host address into binary data using function called "INET_ATON".

Example:
SELECT INET_ATON(ipAddress)AS binary_ip, ipAddress
FROM ip_addresses
ORDER BY binary_ip;