Hello,

I am trying to run a query from a production database onto a dashboard in the office. My dashboard does not allow special characters such as dollar signs, so i need to remove these special characters within my SQL statement.

Currently my SQL statement looks like this:
SELECT SO_Header.Sales_Order, Customer.Sales_Rep, SO_Header.Total_Price, SO_Header.Customer
FROM PRODUCTION.dbo.Customer Customer, PRODUCTION.dbo.SO_Header SO_Header
WHERE SO_Header.Customer = Customer.Customer AND ((SO_Header.Order_Date=dateadd(dd,0,datediff(dd,0,getdate()))))

The column where the special characters are present is (SO_Header.Total_Price)

Can someone help me how i would modify this statement to remove the first/special characters from this column?

Please let me know.

Regards,
Yorke