ADSM-L

"Digit grouping" in SELECT statement

2002-11-26 20:00:38
Subject: "Digit grouping" in SELECT statement
From: Christian Sandfeld <csa AT FERROSAN DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 27 Nov 2002 01:20:43 +0100
Does anybody know how to set digit grouping in a SELECT statement?

I run the following select statement:
SELECT node_name,sum(PHYSICAL_MB) as MB FROM OCCUPANCY WHERE
stgpool_name='TAPEPOOL' GROUP BY node_name ORDER BY MB DESC

The output returned looks like this:

NODE_NAME                                             MB
------------------     ---------------------------------
SERVER01                                       255441.88
SERVER02                                       123943.06
SERVER03                                        55192.80
.
.
.
.


However, I would like to have a delimiter for each three digits so the
output looks something like this instead:

NODE_NAME                                             MB
------------------     ---------------------------------
SERVER01                                      255,441.88
SERVER02                                      123,943.06
SERVER03                                       55,192.80
.
.
.
.


Can it be done?


Regards,

Christian

<Prev in Thread] Current Thread [Next in Thread>
  • "Digit grouping" in SELECT statement, Christian Sandfeld <=