Hi ,
I usually use Modulo operator (% in SQL) to get the decimal or fraction part of the numeric value
eg:
@Num1=8989.678
@Num2=1
@NumDecimalPar = @Num1 % @Num2

my problem is the Modulo in MSSQL works only for Interger data type. Is there way or function w/c I use on getting the decimal/or the fraction part of numeric data type?

my current solution is to covert it to Varchar and use Substring to chop it. then cast it back to numeric data type



Tnx in advance