asked on
Cast currency to a decimal in SQL server
i want to convert a currency field in a SQL server query to a decimal field
Select ISNULL( mrm_amt,0) AS OriginalMRMAmt from contract_rate.
In this query mrm_amt is a currency field and I want to cast it to a decimal. How do I do that?
Select ISNULL( mrm_amt,0) AS OriginalMRMAmt from contract_rate.
In this query mrm_amt is a currency field and I want to cast it to a decimal. How do I do that?
Microsoft SQL Server
Last Comment
k_rasuri
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
if you want to use CONVERT function
SELECT ISNULL(CONVERT(DECIMAL, mrm_amt), 0) AS OriginalMRMAmt FROM contract_rate
SELECT ISNULL(CONVERT(DECIMAL, mrm_amt), 0) AS OriginalMRMAmt FROM contract_rate
CAST( "variable" AS decimal )
If not use the CONVERT function in SQL.