SELECT LEFT(magno, LEN(magno)-1)+ '0' as MagNo, date, SUM(price)FROM TableName GROUP BY LEFT(magno, LEN(magno)-1)+ '0', date
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
brahmam
Login to post response