SELECT CAST(0 AS Y) AS MyNewCurrencyColumn FROM MyTable INTO MyCursor
* or
SELECT $0.00 AS MyNewCurrencyColumn FROM MyTable INTO MyCursor

>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