> 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]
- RE: Non-Stick Session Variables? Mosh Teitelbaum
- RE: Sorting IP Addresses Raymond Camden
- Re: Sorting IP Addresses Michael Dinowitz
- RE: Sorting IP Addresses Barney Boisvert
- Re: Sorting IP Addresses Jochem van Dieten
- Re: Sorting IP Addresses David Delbridge
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Tony Weeg
- RE: Sorting IP Addresses Benjamin S. Rogers
- RE: Sorting IP Addresses Tony Weeg
- Re: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Calvin Ward
- RE: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Benjamin S. Rogers
- Re: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Benjamin S. Rogers
- RE: Sorting IP Addresses Jochem van Dieten
- RE: Sorting IP Addresses Tony Weeg
- RE: Sorting IP Addresses Benjamin S. Rogers
- RE: Sorting IP Addresses Tangorre, Michael