×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Try DIGITS()?
CAST(DIGITs(ANOR) AS CHAR(4)) concat
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of gio.cot via RPG400-L
Sent: Thursday, August 26, 2021 2:09 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: SQLRPGLE Cast Lose Zeros
Hi all
I have this select
Where ODNUD0 = 0 and
ODSTX0 <> 'A' and
CAST(ANOR AS CHAR(4)) concat
CAST(NUOR as CHAR(7)) concat
CAST(NURG as CHAR(7)) < :AnnoNumeRiga And
odcar0 = :B9CDARTL ;
AnnoNumeRiga is a field that contains Year order number and row number like 202100002030000003; the result of
CAST(ANOR AS CHAR(4)) concat
CAST(NUOR as CHAR(7)) concat
CAST(NURG as CHAR(7))
Is "2021203 3"
How can do to leading the zeros in cast so that i have "202100002030000003"
instead of "2021203 3"
Thanks in advance
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
