Re: Converting alpha to numeric in Query

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

You don't even need cast(), just use the data type, such as float() or zoned()

At 03:28 PM 4/2/02 -0500, you wrote:
>In SQL you can use the CAST() function to convert from alpha to numeric.
>But if you are talking about Query/400 - no.
>
>
>On Tue, 2 Apr 2002 11:31:36 -0800, York, Albert wrote:
>
> >Is there a way in Query to convert in alpha field to a numeric field. The
> >field will always contain valid digits.
> >
> >Albert York
> >_______________________________________________
> >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> >To post a message email: MIDRANGE-L@midrange.com
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> >or email: MIDRANGE-L-request@midrange.com
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/midrange-l.
> >
>
>
>Rich Herdman
>email: rherdman@columbus.rr.com
>www:  http://home.columbus.rr.com/herdman/
>
>"It never does to leave a live Dragon out
>of the equation." - Bilbo Baggins, 'The Hobbit'
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.