hennessym
asked on
In SQL Server, how do I convert Hex IP addresses to dotted ip addresses?
I have a table in SQL Server 2005 containing a number of hexadecimal ip addresses. I'd like to convert them to dotted ip addresses, either via SQL or ASP.NET.
Can anyone offer tips on how to achieve this?
Thanks in advance,
Matt
Can anyone offer tips on how to achieve this?
Thanks in advance,
Matt
ASKER
Well, let's say the ip address = 127.0.0.1. The field value = 7F000001.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, worked perfectly!
Cheers, Andrew