 |
IT-Interview.com:Open Database for IT Professionals to share interview questions, answers and knowledge. |
Open Question
How can you change to get the decimal separator as comma instead of the decimal point (.)?
(Time Left: 0 days 0 hours)
asked by: oxidised on: Aug 21, 2009 Answers ( 2 )
Use stuff(convert(varchar qty) charindex("." convert(varchar qty)) 1 " ")
totoroxxx answered on：Aug 22, 2009 0 comments 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
bloodlust answered on：Aug 23, 2009 0 comments Hot Questions