Chapter 6: Using and Creating Datatypes

Working with money datatypes

If you are combining money and literals or variables, and you need results of money type, use money literals or variables:

create table mytable
(moneycol money,)
insert into mytable values ($10.00)
select moneycol * $2.5 from mytable

If you are combining money with a float or numeric datatype from column values, use the convert function:

select convert (money, moneycol * percentcol)
    from debits, interest
drop table mytable