i know i can do the floor() on a decimal number and then store that to a variable and subtract it from the original number

example

@a = 2.75

@b-2 = floor(2.75)

@C = @a - @b-2 (this gives me 0.75)

but is there a function that does this in SQL Server

Cheers,

Chandra