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 .

Answer 1

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