No, there is no provision for special formatting of numbers. You would
need some other program to format the numbers as you like. For example, if
you use Microsoft Excel to query the TSM server via the TSM ODBC driver,
you can format the columns in Excel to display numeric values with the
desired separators.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




"Rupp Thomas (Illwerke)" <thomas.rupp AT ILLWERKE DOT AT>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/01/2003 09:22
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Format numbers



Hi *SM-ers,

I would like to format the numbers I get from a SQL Select.
1558195645 should look like 1.558,195.645

Can this be done with SQL?

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG