Re: Convert to Numeric

several choices

    *    the "CAST" function
                CAST <expression> AS <data-type> | NULL

    *    the "CHAR" function
                CHAR(<decimal expression [,decimal character])

    *    the "DIGITS" function
                DIGITS(<expression>)

Rolf

Dipl.Inf.(FH) Rolf P Mittag
IBM Partner In Development
Leipziger Str. 50
D-69214 Eppelheim
eMl: rm@r-m-e-d-v.de
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26

----- Original Message -----
From: "Jonathan Oblea" <JOBLE@amkor.com>
To: <RPG400-L@midrange.com>
Sent: Friday, December 01, 2000 7:40 AM
Subject: Convert to Numeric


>
>
>
> Hi All,  Does anyone knows how to convert character values to numeric
values
> using SQL ?
>
> Thank you in advance.
>
> Regards,
> Ian
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---