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