On My MSSQL 2008 server i am running the following part of query. ( i am not writing the whole query as it is unnecessary)
(CASE WHEN Currency = 'USD' THEN PriceOfSale WHEN Currency = 'EUR'
THEN PriceOfSale * EurVsUsdParite ELSE 0 END) AS USD
I have 2 needs to be corrected
1 ) , the results come up as ( random numbers are given )
0.1 or 5.7 , however i need it to display as 0,1 5,7 (comma instead of dot)
2) i need to add some code to display the data as
0,1 USD or 5,7 USD , how can i do that.
Thanks in advance