Hello,
select 1.23
select cast(replace(cast(1.23%1.0 as varchar),'0.','') as int)
select 52.89
select cast(replace(cast(52.89%1.0 as varchar),'0.','') as int)
select 456.589
select cast(replace(cast(456.589%1.0 as varchar),'0.','') as int)
Output:
input
1.23
decimals
23
input
52.89
decimals
89
input
456.589
decimals
589