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)