Which version of SQL? MS, Postgre, MySQL, Oracle?
On Wed, Jul 29, 2015 at 9:23 AM, Kehl Reto <[email protected]> wrote:
> need sql query for ip addresses sorted ascending but can’t get the 4th
> octet
>
>
>
> SELECT
>
> IPAddress0, DNSHostName0
>
> FROM v_GS_NETWORK_ADAPTER_CONFIGURATION
>
> WHERE (v_GS_NETWORK_ADAPTER_CONFIGURATION.IPEnabled0 = 1)
>
> ORDER BY
>
> CAST(SUBSTRING(IPAddress0, 1, CHARINDEX('.', IPAddress0) - 1) AS tinyint),
>
> CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0) + 1, CHARINDEX('.',
> IPAddress0, CHARINDEX('.', IPAddress0) + 1) - CHARINDEX('.', IPAddress0) -
> 1) AS tinyint),
>
> CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.',
> IPAddress0) + 1) + 1, CHARINDEX('.', IPAddress0,
>
> CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1) + 1)
>
> - CHARINDEX('.', IPAddress0, CHARINDEX('.', IPAddress0) + 1)
> - 1) AS tinyint)
>
> --CAST(SUBSTRING(IPAddress0, CHARINDEX('.', IPAddress0, CHARINDEX('.',
> IPAddress0, CHARINDEX('.', IPAddress0) + 1) + 1) + 1, 3) AS tinyint)
>
>
>
>
>
>
>
> the last CAST(SUBSTRING(…. gives error when activated.
>
> I can’t get it, way too complicated for me..
>
>
>
> anybody?
>
>
--
Daniel Rodriguez
[email protected]
