Re: SQLRPGLE Cast Lose Zeros

[erifam@xxxxxxxxx]

Way don't you use digits instead of cast + char

gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> schrieb am Do., 26. Aug.
2021, 20:07:

> 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