Home Forums SQL Server 2005 SQL Server 2005 Integration Services Get the fractional part of a decimal with SSIS Expressions RE: Get the fractional part of a decimal with SSIS Expressions
Daniel Bowlin
SSC-Dedicated
Points: 34566
More actions
February 19, 2013 at 8:20 am
#1589226
How about
1.2 - FLOOR(1.2)
Floor returns the largest integer that is less than or equal to the numeric expression