You can remove the prefix.

Or use format(…,’C’) for your local currency you set up in Windows Control panel. More details here: https://database.guide/how-to-format-numbers-as-currency-in-sql-server-t-sql/