<p>In Informix, how can I cast a <code>char(8)</code> type into a <code>money</code> type, so that I can compare it to another <code>money</code> type?</p>

<p>Using "<code>tblAid.amt::money as aid_amt</code>" did not work.
Using "<code>(tblAid.amt * 1) AS aid_amt</code>" did not work.</p>

try this -->
```
```
select (disb_amt::NUMERIC) disb_amt from tmp_kygrants;
```
```
You may be able to compare the amounts as numeric.