storing IP addresses in SQL database and sorting
Posted on 2014-03-19
developing an app in lightswitch using data stored in SQL server. one of the fields is IP address and I need to be able to sort by IP address.
One suggestion was to split the ip into four columns 3 digits each but that is ugly for entry and reporting.
the other was to enter the IP address with zeros such as 192.168.001.001 again not a good option
the third options was try to create a computed column that coverts the IP address to a sortable number by inserting the zeros or converting binary whatever is necessary
I think this is the best option but I have to idea how to do this in SQL I created a computed column but need assistance with the formula