VAR Char to Dollar Format

Question

Lauren Sloan 0

I have a column totalAmount and want to convert so that the amount is in US Dollar format.

Example: 9729.20 and I want it to read $9729.20 in display.

Viorel 102.4K Reputation points

2023-09-06T21:14:25.1166667+00:00

Do you mean update MyTable set totalAmount = '$' + totalAmount?
PercyTang-MSFT 9,131 Reputation points Microsoft Vendor

2023-09-07T05:58:19.7066667+00:00

Hi @Lauren Sloan

If you only need to display $9729.20, you can try Erland's method.
PercyTang-MSFT 9,131 Reputation points Microsoft Vendor

2023-09-26T09:01:20.7733333+00:00

Hi,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Viorel 102.4K Reputation points

2023-09-06T21:14:25.1166667+00:00

Do you mean update MyTable set totalAmount = '$' + totalAmount?
PercyTang-MSFT 9,131 Reputation points Microsoft Vendor

2023-09-07T05:58:19.7066667+00:00

Hi @Lauren Sloan

If you only need to display $9729.20, you can try Erland's method.
PercyTang-MSFT 9,131 Reputation points Microsoft Vendor

2023-09-26T09:01:20.7733333+00:00

Hi,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

Erland Sommarskog 87,431

SELECT concat('$', TotalAmount) FROM tbl

However, normally you do formatting like this in the presentation layer.

Answer 2

Naomi 7,361

Try

SELECT FORMAT(100999.99,'C')

2 answers