How can you change to get the decimal separator as comma instead of the decimal point (.)?

Interview Candidate
Jun 27th, 2007
3
5524

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

dkreddi
Profile Answers by dkreddi

Nov 19th, 2007

Use stuff(convert(varchar,qty),charindex(".",convert(varchar,qty)),1,",")

debadritab
Profile Answers by debadritab

Jun 24th, 2008

declare @source varchar(30)
select @source = "10.236.155.17"
while charindex(".",@source) > 0
begin
select @source = stuff(@source,charindex(".",@source),1,",")
end
select @source

protech
Profile Answers by protech

Jul 15th, 2010

declare @mod_string varchar(20)
select @mod_string = str_replace("1234.567",".",",")
select @mod_string