- Calvin
----- Original Message -----
From: Benjamin S. Rogers
To: CF-Talk
Sent: Thursday, October 16, 2003 4:38 PM
Subject: RE: Sorting IP Addresses
> that doesn't work perfectly.
>
> 166.141.22.4
> 166.141.22.40
> 166.141.22.41
> 166.141.22.47
> 166.141.22.48
> 166.141.22.5
Sorry about that. I forgot to convert the substrings to integers. Try
this:
SELECT *
FROM SourceIPSpamCount
ORDER BY
CONVERT(INT, SUBSTRING(SourceIP, 1, CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, SUBSTRING(SourceIP, CHARINDEX('.', SourceIP) +
1,CHARINDEX('.', SourceIP, CHARINDEX('.', SourceIP) + 1) -
CHARINDEX('.', SourceIP) - 1)),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1, CHARINDEX('.', REVERSE(SourceIP), CHARINDEX('.',
REVERSE(SourceIP)) + 1) - CHARINDEX('.', REVERSE(SourceIP)) - 1))),
CONVERT(INT, REVERSE(SUBSTRING(REVERSE(SourceIP), 1, CHARINDEX('.',
REVERSE(SourceIP)) - 1)))
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
