mercredi 8 juin 2016

Thousand separator to large number in SQL Server 2005

We have a table where we are using a column to store the price of the item. The column size is 17.2 decimal. We need to have both thousand separator and decimal separator in the string. We are currently using this:

SELECT '$' + convert(varchar,cast('2123232322323.21' as money),-1) as Price

But it raises an error if the size exceed 15 digits.

Aucun commentaire:

Enregistrer un commentaire