I want to do something like this:

SELECT 0 AS MyNewCurrencyColumn FROM MyTable INTO MyCursor

but I want MyNewCurrencyColumn to be a currency type.
If there were any currency columns in the table, I could do this:

SELECT SomeCurrencyColumn * 0 AS MyNewCurrencyColumn FROM MyTable INTO MyCursor

But what if there are no currency columns in the table?
Is there anyway to select a literal and use the AS clause and specify the data type?

Thanks