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