Skip to Content
0
Former Member
Jun 11, 2009 at 12:41 PM

varchar to 2 decimal points ?!

36 Views

Hi,

I have the below code; which I need to set the Line Total to 2 decimal points but it is a varchar since I want to attach the currency symbol to it:

{CASE

WHEN T0.DocCur = 'EUR' THEN CONVERT (varchar(50), T0.DocCur) + ' ' + CONVERT (varchar(50), T1.LineTotal)

ELSE CONVERT (varchar(50), T0.DocCur) + ' ' + CONVERT (varchar(50), T1.TotalFrgn)

END as 'Line Total'}

Appreciate your help.

Thanks