The problem is the IS_NULL functions that I pointed you towards.
I didn’t release the data types in the prior post.
You can’t have a blank value in a field which is a numeric data type (of which the money data type is one).
Try changing the IS_NULL functions to this.
<pre>SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, oas_balance.el2, oas_balance.full_value,
CASE WHEN balcode = ‘ACTUAL’ AND yr = ‘2008’ And period = ‘6’ AND IsNull(full_value, -1) = -1 THEN 0 ELSE full_value END AS Act_Amt,
…</pre>
Discuss This Question: 1  Reply