InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:57:03 GMT20http://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxUse STR function. E.g:[code="sql"]declare @x money=12345.69851SELECT [STR]=STR(@x, 20, 2), [CONVERT_default]=CONVERT(varchar(20), @x), [CONVERT_format_1]=CONVERT(varchar(20), @x, 1), [CONVERT_format_2]=CONVERT(varchar(20), @x, 2)[/code]Mon, 05 Nov 2012 18:09:10 GMTVedran Kesegichttp://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxcast the inner sum as decimal then case the whole output as varcharMon, 05 Nov 2012 05:53:22 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxMy charge amount need to cater for both "Then" and "Else", my "else" returns string hence I cast it as varchar. that code so far is working but I need to return two decimal value amount.Mon, 05 Nov 2012 05:51:59 GMThoseamhttp://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxis your chargeAmount is INT then you need to convert it to decimal to get decimal in SUMMon, 05 Nov 2012 05:36:19 GMTBriPanhttp://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxYou will need to convert it to a data type which allows you to specify the amount of decimal places you want, you would want decimal with the correct precision to cope with how ever many decimal places you need.Mon, 05 Nov 2012 05:32:59 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381020-392-1.aspxHiI have this code herecase when chargeType <> 'ADV_SWITCH_FEE' then CAST(isNull(sum(chargeAmount)/100.0, 0.0) AS VARCHAR) else '' end as chargeAmountHow do I convert my "sum" into decimal places?Mon, 05 Nov 2012 05:31:07 GMThoseam