<div>
This should do the trick.<br />
<br />
CAST( &nbsp; &nbsp;&quot;variable&quot; &nbsp;AS &nbsp; decimal &nbsp; &nbsp;)<br />
<br />
If not use the CONVERT function in SQL.
</div>


This should do the trick.

CAST(    "variable"  AS   decimal    )

If not use the CONVERT function in SQL.

<div>
if you want to use CONVERT function<br />
<br />
SELECT ISNULL(CONVERT(DECIMAL, mrm_amt), 0) AS OriginalMRMAmt FROM contract_rate
</div>


if you want to use CONVERT function

SELECT ISNULL(CONVERT(DECIMAL, mrm_amt), 0) AS OriginalMRMAmt FROM contract_rate

<div>
<div class="content wysiwyg-content">
i want to convert a currency field in a SQL server query to a decimal field<br />
<br />
Select ISNULL( mrm_amt,0) AS OriginalMRMAmt from contract_rate.<br />
<br />
In this query mrm_amt is a currency field and I want to cast it to a decimal. How do I do that?
</div>
</div>


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?

Cast currency to a decimal in SQL server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.