below did it

update dbo.testtable set testcode = substring(testcode,1,len(testcode)-1)

Thanks

I have script task that does data validation and manipulation using custom dll's and i need to store data into database after data validation. It has to be in script...