SQL Decimal separator

Question

I have this query

SELECT LEFT( CONVERT(VARCHAR, CAST(RUNNING_BALANCe AS MONEY), 1), LEN( CONVERT(VARCHAR, CAST(RUNNING_BALANCe AS MONEY), 1)) - 1) 
from load_transaction_history
WHERE  [POSTED_ON] between '2008-06-10' and '2008-06-15' and account_number='12345678'
order by posted_on

Now the problem is that the ammounts i ger are like so 6,471,538.30 however being in Europe, i want the decimal separators like so

6.471.538,30 ...is there a way to do this is SQL...i tried copy paste in excel but formatting doesn't work.....

Answer 1

For your logon in SQL server set default language to something european.

Answer 2

I think you have to change the locale using this

SET LANGUAGE British English

Answer 3

You could always just replace them yourself:

SELECT LEFT( REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, CAST(RUNNING_BALANCe AS MONEY), 1), '.', '$'), ',', '.'), '$', ','), LEN( CONVERT(VARCHAR, CAST(RUNNING_BALANCe AS MONEY), 1)) - 1)
from load_transaction_history
WHERE  [POSTED_ON] between '2008-06-10' and '2008-06-15' and account_number='12345678'
order by posted_on