Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Sorting varchars that contain IP addresses
I am trying to retrieve a list of IP numbers that are stored as character strings. When I sort them, I want them in "numerical" order, but since they are strings, they get sorted as text, e.g.:
129.83.149.10 129.83.149.11 129.83.149.2 129.83.149.21
What I want is:
129.83.149.2 129.83.149.10 129.83.149.11 129.83.149.21
Any good ideas?
Thanks - Joe Received on Tue Jul 22 1997 - 00:00:00 CDT
![]() |
![]() |