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
