1> /* Another example using money, calculations, and formatting. */ 2> /* */ 3> use pubs2 1> /* */ 2> select distinct advance, advance * 2.5 as BigAdvance, 3> '$', advance * 2.5 as "$ and BigAdvance", 4> '$'+ convert(char(12), convert(numeric(8,2), advance * 2.5)) as 5> NiceFormatBigAdvance 6> from titles 7> where advance is not null and advance > 2000 advance BigAdvance $ and BigAdvance NiceFormatBigAdvance ------------------------ ------------------------- - ------------------------- -------------------- 2,275.00 5687.50000 $ 5687.50000 $5687.50 4,000.00 10000.00000 $ 10000.00000 $10000.00 5,000.00 12500.00000 $ 12500.00000 $12500.00 6,000.00 15000.00000 $ 15000.00000 $15000.00 7,000.00 17500.00000 $ 17500.00000 $17500.00 8,000.00 20000.00000 $ 20000.00000 $20000.00 10,125.00 25312.50000 $ 25312.50000 $25312.50 15,000.00 37500.00000 $ 37500.00000 $37500.00 (8 rows affected)