Re: Char to Numeric in STRSQL

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Vijosh A wrote:
> 
> I want to convert a character field to numeric in interactive  SQL. The
> field is 18 chars long and data in it looks like this - '000000000000004.56'
> . This field will have data of this type only. I need to take totals,
> subtotals etc. of this field. Can anyone help?
> 

select sum(decimal(char_field, 18, 2)) from ...

result is the same as a cast:  CAST(char_field as decimal(18,2)) ...


-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---