Thanks, I got the answer.  Paul hit it on the head.  My summary of clients
is given by the SQL query:

select platform_name as OS, -
  client_os_level as OS_VER, -
  cast( cast(client_version as char(2)) || '.' -
  || cast(client_release as char(2)) || '.' -
  || cast(client_level as char(2)) || '.' -
  || cast(client_sublevel as char(2)) -
    as char(15)) as "Client", -
  count(*) as "Count" -
 from nodes -
  group by platform_name, -
    client_os_level, client_version, client_release, client_level,
client_sublevel -
  order by OS, OS_VER, "Client"

My main issue was trying to put the "Client" aggergate in the order by
clause.  Instead, I had to put each of its components in the group by
clause, and then order by clause can contain the name of the casted column
("Client")

> -----Original Message-----
> From: Paul Ripke [SMTP:[EMAIL PROTECTED]
        [Coats, Jack]  [sip]

Reply via email to