Re: sql select without editing numbers

SELECT
VARCHAR_FORMAT(1234.56,'999999999D999') AS NUMBER
FROM SYSIBM.SYSDUMMY1


Regards,
Steve Landess
(512) 289-0387
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Jim Franz <franz9000@xxxxxxxxx>
Sent: Wednesday, February 12, 2025 14:46
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: sql select without editing numbers

I'm sure its a simple thing, but i need the Order column numbers to not
have commas (user requests like 2450245). DDS defined tables, packed 7,0
Google full of hacks that db2 doesn't do.

CUST TRAN_CODE ORDER Ref
ESW01 25 2,450,245 Widgets
ESW01 25 2,453,785 Bolts

when i use varchar_format it pads spaces to the right of column and trim
seems to be ignored
tia
Jim Franz
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7C%7C23203b452f1f48e1faf108dd4ba7ca7d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638749906213661768%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=J7vQrD8Wwj2cC7akdJTUDyUoR7HbL6cvC5rQVfewSnw%3D&reserved=0<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=05%7C02%7C%7C23203b452f1f48e1faf108dd4ba7ca7d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638749906213681716%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=MULn2Bdp3SZOfc07eW25AkkLgNBGaHRq1%2FrGLjLoB90%3D&reserved=0<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.