@NumDecimalPar = @Num1 - CAST(@Num1 AS int)

> 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