title: SQL replace dot with comma
body: <p>I have following code:</p>
  
  <pre><code>SELECT cast(Listenpreis*1.19 as decimal(29,2)) as Listenpreis
   FROM [SL_M03KNE].[dbo].[ARKALK]
  </code></pre>
  
  <p>I get this value: 5.59</p>
  
  <p>I try to replace the dot to a komma so i get the Value: 5,59</p>
  
  <p>I try the code:</p>
  
  <pre><code>SELECT replace((cast(Listenpreis*1.19 as decimal(29,2)) as Listenpreis),'.','))
   FROM [SL_M03KNE].[dbo].[ARKALK]
  </code></pre>
  
  <p>But something is wrong with the Syntax. Any Ideas?</p>
  
  <p>I found out: if I do a </p>
  
  <pre><code>select Artikelnummer,Listenpreis*1.19 as money from [SL_M03KNE].[dbo].[ARKALK]
  </code></pre>
  
  <p>i get: 5,59</p>
  
  <p>If i do a</p>
  
  <pre><code>EXEC master..xp_cmdshell 'bcp "select Artikelnummer,Listenpreis*1.19 as money from [SL_M03KNE].[dbo].[ARKALK]" queryout "D:\shop\xml\Artikelpreise_ohne.csv" -E -c -T -x
  </code></pre>
  
  <p>the bcp do a conversion from the komma to dot. How can i fixed this?</p>