Remove decimal point from all values

Question

I have imported a table into synapse. The issue is that the column values have a decimal point which i want to remove.

Current value:
1.345698
0.046378
10.85364

How i want it:
1345698
46378
1085364

Whats the best approach of doing it?

Answer 1

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