How convert oracle select function to sql server

[yosiasz]

have you looked at the answers provided to you here?

Create query to get number after decimal point

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