RE: [Emerald] Statistics

Emerald ( (no email) )
Wed, 1 Dec 1999 16:22:00 -0500

> Didn't quite think this was what you intended:
>
> NASIdentifier Speed
> ---------------- ----------- -----------
> 127.0.0.1 NULL 64
> 199.79.131.219 NULL 24118
> 199.79.131.70 NULL 56713
> 199.79.131.72 NULL 57641
>

Try it this way:

Select NASIdentifier, LEFT(ConnectInfo,5), Count(*)