RE: Query 400: can an alpha field be converted to numeric?

This is great.

Who came up with this novel approach?  It works great!!

Thanks!


-----Original Message-----
From: mkrouse@xxxxxxxxxxxxxxx [mailto:mkrouse@xxxxxxxxxxxxxxx]
Sent: Monday, April 26, 2004 8:58 AM
To: Midrange Systems Technical Discussion
Subject: Re: Query 400: can an alpha field be converted to numeric?


It's not pretty and I wonder about users being capable, but you can 
convert them using the MICROSECOND function.  If the field is six digits 
or less its fairly straightforward, if they're more than six or have 
decimels it gets complicated quick.  The simplest would be a six character 
field, no decimels, and would go like this where SIXCHAR is the input 
character field and SIXDIGIT is the numeric result field.

DATETIME     '2004-01-01-01.00.00.' || SIXCHAR

SIXDIGIT        MICROSECOND(DATETIME)    6 0

If it has decimels you add another line to divide it by the appropriate 
number.  If it's longer than six, you have to do it more than once and put 
them together using numeric functions.






"Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/25/2004 11:44 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Query 400: can an alpha field be converted to numeric?






Users want to convert an alpha field (containing all numeric characters) 
to
a numeric field so they can do arithmetic operations.

Is there any way to do this in Query/400?

Any creative ideas how to do this?

Maybe using some of the date functions?

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.