Steven Yong's Weblog

Wednesday, March 29. 2006

IP sorting problem

In one of the projects, we store the client's IP address (for audit purpose) as varchar. Therefore by default if we sort them using SQL, "60.1.1.1" comes after "101.1.1.1". Unfortunately we are requested to sort the IP addresses like number, means 60.1.1.1 followed by 101.1.1.1. If you've encountered this issue before, kindly share me some ideas.

Posted by Steven Yong in computer at 16:00 | Comments (6) | Trackbacks (0)

...

(Page 1 of 1, totaling 1 entries)

Picture of the week