Conversion nvarchar to decimal

Question

SELECT NOM ,Sum(CAST(SOLDE AS float)) AS _solde
FROM tab 
WHERE NUM_CLIENT='550322' 
GROUP BY NOM

I have a result without comma ,SOLDE is something like that 66,11 i want a result respecting a comma .

what Type is SOLDE ? Add schema, some data sample and expected results, please — Horaciux, May 29 '14 at 21:22
Can you retry the wording for your question? It does not make sense. — johnny, May 29 '14 at 21:23
`SOLDE is something like that 66,11` how can you convert that to float? — Rahul, May 29 '14 at 21:30

woot · Accepted Answer · 2014-05-29T21:57:35.137

0

SQL Server does not respect locale settings for varchar to number conversions, so you will need to replace the comma with a decimal first.

SELECT NOM ,Sum(CAST(REPLACE(SOLDE,',','.') AS float)) AS _solde
FROM tab 
WHERE NUM_CLIENT='550322' 
GROUP BY NOM

edited May 29 '14 at 21:57

answered May 29 '14 at 21:40

woot

1 Answers1