CODEWITHSUNDEEP
sql
Emre MAVZER
Emre MAVZER

Reputation: 47

SQL - Show point instead of comma as decimal separator

CAST(CONVERT(VARCHAR, CAST(FF.AlinanFF AS MONEY), 1) AS VARCHAR) AlinanFF

Data is shown in this format:

AlinanFF
2,642.11

I want to display the data in this way:

AlinanFF
2.642,11

'AlinanFF' format nvarchar

Upvotes: 0

Views: 778

Answers (2)

Ishan
Ishan

Reputation: 295

SELECT REPLACE(SUBSTRING('2,642.11',1,CHARINDEX('.','2,642.11')-1),',','.')+REPLACE(SUBSTRING('2,642.11',CHARINDEX('.','2,642.11'),1000),'.',',') as AlinanFF

Upvotes: 1

Bikram Limbu
Bikram Limbu

Reputation: 441

SELECT REPLACE(REPLACE(REPLACE('2,642.11','.','^'),',','.'),'^',',') AS AlinanFF

Upvotes: 1

Related Questions