[GENERAL] order by

[Kaj-Michael Lang]

I have stored IP's in a table using a varchar(15) field. My problem is how
to make the order by list the IP's the correct order like: 

192.168.1.1
192.168.1.6
192.168.1.10

now it sorts them like:

192.168.1.1
192.168.1.10
192.168.1.6

is it possible to get them sorted the right way ?

------------------------------------------------------------------------------
Kaj-Michael Lang                [EMAIL PROTECTED]
Kaskentie 5 C9                  http://www.tal.org/
20720 Turku                     ftp://ftp.tal.org/
FINLAND                         [EMAIL PROTECTED]
------------------------------------------------------------------------------
               Keyboard not found - press any key to continue
------------------------------------------------------------------------------