try this
select Replace((a.app_name +', '+ isnull(a.gar_name,'')+ ', ' + isnull(a.source_vill,'')+ ', ' + isnull(a.source_place,'') + ', ' + isnull(a.source_Dist,'')),', ,',',') as Address , CONVERT(nvarchar,f.Cheque_Draft_dt,103) as sac_dt ,f.amount, bal= (Select ((select SUM(amount) from viv_fund where financialYear='2010-2011' and type='in' ) - isnull(SUM(amount),0))-f.amount from viv_fund where uniqueid < f.uniqueid and financialYear='2010-2011' and type='out' ) from viv_fund f inner join viv_app a on a.app_Id=f.app_Id where f.financialYear ='2010-2011' and a.financialYear='2010-2011' and type='out' order by uniqueid desc
In the above query i am using replace method. Whenever i find string as , , i am replacing it with ,.