Why don't you handle this similar to the way Microsoft handles Ranged IP Boundaries in SCCM? It takes the starting address and ending address and performs the following conversion on each of the two IP Addresses:
1) Each of the four octets is converted to its binary equivalent in 8 binary digits 2) Each of these binary numbers is concatenated in a string to form a 32-bit binary number 3) This 32-bit binary number is then converted to a decimal integer for storage. For example the IP Address of 192.168.100.123 would be converted as follows: 1) Each of the four octets is converted to its binary equivalent in 8 binary digits (11000000.10101000.01100100.01111011) 2) Each of these binary numbers is concatenated in a string to form a 32-bit binary number (11000000101010000110010001111011) 3) This 32-bit binary number is then converted to a decimal integer for storage (3232261243) You can reverse the process to convert back to an IP Address. Thanks, ________________________________ Mark Mears [email protected]<mailto:[email protected]%0d> Phone: (757) 945-2651 [cid:[email protected]]<http://www.cireson.com/> [cid:[email protected]]<http://twitter.com/teamcireson> Check out our System Center App Store: www.cireson.com/app-store ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Rajkumar Bhoopathy Sent: Friday, November 8, 2013 7:59 AM To: [email protected] Subject: [mssms] Float to Varchar (RoamingBoundaryIPrange) Hello All : Please excuse me if this already answered many times in the forums.. I would like to convert the float value to varchar of Starting and Ending IP address from RoamingBoundaryIPrange. Can you please help me with some samples how to do this.. I'm writing some report to get these data. select * from RoamingBoundaryIPrange order by DisplayName Regards / Raj...
<<inline: image002.png>>
<<inline: image004.jpg>>
