MSSQL How to get numbers after the decimal

  Select Decimal, Decimal % 1 as Truncated
  FROM TestingDecimal3
  Where Decimal % 1  > 0
 
  Select Float, (Convert(decimal(5,2),Float) % 1) as Truncated
  From TestingDecimal3

Youtube example