Hey,
assuming this is a 1 time activity, you can use a tsql query to update
create table #test
(
c1 decimal(10,3)
)
insert into #test
Select 1.235 union
select 0.003 union
select 0.234
Update #test
set c1=replace(c1,'.','')
Select * from #test
output :
If you dont need 000 at the end, you need to update the datatype of column to varchar/int