Re: Alpha to Numeric converion issue

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

Dec(sourceCharValue,5,0)

Jay


> On Apr 24, 2019, at 7:56 AM, Steinmetz, Paul via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> I'm extracting a value from source code.
> The values range from "1    " to "99999",  5 alpha field.
>
> I need the end result in a numeric field, 5.0 zoned decimal acceptable, packed preferred.
> "00001" "99999".
>
> Current process is within an AS/400 query.
> SQL or custom RPGLE program  our options.
>
> Any thoughts from the group?
>
> Thank You
> _____
> Paul Steinmetz 
> IBM i Systems Administrator 
>
> Pencor Services, Inc. 
> 462 Delaware Ave 
> Palmerton Pa 18071 
>
> 610-826-9117 work 
> 610-826-9188 fax 
> 610-349-0913 cell 
> 610-377-6012 home 
>
> psteinmetz@xxxxxxxxxx 
> http://www.pencor.com/
>
>
>
>
>
> -- 
> 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://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://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com