× 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.



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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.