forum

Home / DeveloperSection / Forums / remove unwanted zero form column

remove unwanted zero form column

Manoj Bhatt 2403 05-Jan-2013
Hi Guys,

I need the query for sql server 2008 which remove the extra zeroes in the columns below is my table structure and values
CREATE TABLE[dbo].[tblZeroes]
(
   iSrNum int PRIMARY KEY IDENTITY,
   vNumbers varchar(20)
)
INSERT INTO [dbo].[tblZeroes] VALUES('00001')
INSERT INTO [dbo].[tblZeroes] VALUES('001.00')
INSERT INTO [dbo].[tblZeroes] VALUES('00001000')
INSERT INTO [dbo].[tblZeroes] VALUES('00.001')
INSERT INTO [dbo].[tblZeroes] VALUES('0.10')

Thanks

Updated on 05-Jan-2013

Can you answer this question?


Answer

1 Answers

Liked By