Re: SQL Query

[mgarrison@xxxxxxxxxx]

John Mathew wrote on 12/03/2012 09:24:58 AM:

> From: John Mathew <johnmathew400@xxxxxxxxx>
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>, 
> Date: 12/03/2012 09:25 AM
> Subject: SQL Query
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
>
> Hi All,
>  
>  Iam trying to sum field and then converting it into decimal.
> The orginal field type is packed with no decimal.
>  
> SELECT DEC(SUM(Field),11,2) FROM File WHERE ABBA = 
> 111483                                                          
>  
> Output of the query
>  
>   DEC  
>   4,325.00
>  
> But the output what I wanted is 43.25
>  
> Not sure how to achieve the task. Can you some one please suggest.
>  
> Thanks in advace.
>  
> Jo
> -- 
> 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.

The following will convert your "Field" values to 2 decimals:

SELECT DEC(SUM(Field/100),11,2) FROM File WHERE ABBA = 111483