RE: Using SQL to convert an alpha field to numeric

Hi Rob
Just got back to my desk
Thanks for both e-mails
I understand about the function and agree
If this proceeds further, I may have to use this

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, March 08, 2018 4:43 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Using SQL to convert an alpha field to numeric

Another thing about using a function...
It makes it easier to do views giving you the format desired.

create view mylib.myview
select a.f8, ConvertToNumber(a.f8) as NumericF8 from myfile a

Then you can query this view instead of having to put that logic into all your queries.


Rob Berendt