declare @first_part char(20), @second_part char(34), @third_part char(7), @forth_part char(37) declare @b char(8), @uB char(8) declare @bottles tinyint set @bottles = 99 set @b =' bottles' set @uB =' Bottles' set @first_part=' of beer on the wall' set @second_part='Take one down and pass it around, ' set @third_part='no more' set @forth_part='Go to the store and buy some more...' while @bottles>0 begin if @bottles=2 begin print con