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

DIGITS returns an alpha string, not a numeric value...
Somewhat of a misnomer, wouldn't you say?

Steve

----- Original Message ----- 
From: "Al Barsa" <barsa@xxxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Sunday, April 25, 2004 11:29 AM
Subject: Re: Query 400: can an alpha field be converted to numeric?


>
>
>
>
>
> It's been a long time, but look for the "digits" function in Query.
>
> Al
>
> Al Barsa, Jr.
> Barsa Consulting Group, LLC
>
> 400>390
>
> 914-251-1234
> 914-251-9406 fax
>
> http://www.barsaconsulting.com
> http://www.taatool.com
>
>
>
>
>              "Stone, Joel"
>              <StoneJ@GourmetAw
>              ard.com>                                                   To
>              Sent by:                  "'Midrange Systems Technical
>              midrange-l-bounce         Discussion'"
>              s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>
>                                                                         cc
>
>              04/25/2004 11:44                                      Subject
>              AM                        Query 400: can an alpha field be
>                                        converted to numeric?
>
>              Please respond to
>              Midrange Systems
>                  Technical
>                 Discussion
>              <midrange-l@midra
>                  nge.com>
>
>
>
>
>
>
> 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.
>
>