AW: SQL SELECT displaying commas in numerics

Hi,

May be this is not the answer you expected ...

AFAIK there is no option in interactive SQL to remove the thousands
separator.
But when executing the same SQL statement with iNavigator's Run an SQL
Script, thousands separators will never be displayed.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Dan
Gesendet: Wednesday, 17. December 2008 19:56
An: Midrange Systems Technical Discussion
Betreff: SQL SELECT displaying commas in numerics

In interactive SQL, numerics by default display with commas for the
thousands separator. Is there a way to lose the commas?

Note that I'm using SELECT * FROM CUSTMAST, and I really don't want to list
every field in the file to have to use DIGITS(CUSTNO).

I looked at changing the session attriubtes (F13), where you get choices for
the decimal point, and for date & time format / separators, but nothing for
thousands' separators.

TIA,
Dan