order by

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        milang@tal.org
Kaskentie 5 C9            http://www.tal.org/
20720 Turku            ftp://ftp.tal.org/
FINLAND                klang@abo.fi
------------------------------------------------------------------------------
               Keyboard not found - press any key to continue
------------------------------------------------------------------------------