How can I do MOD arithmatic in 7.0? 2

[Will192]

I have tried using the FLOOR funciton, but run into rounding problems. Is there an alternate to writing a MOD procedure?

Thanks in advance for any responses to this post.

Will Summers

 

[NathanGriffiths]

Hi,

There is a modulus (MOD) operator in T-SQL: %

e.g.

SELECT 10 % 4

returns:

------
2

if this is what you are looking for.

Nathan

 

[essa2000]

Dear ;

You can round off using the same function in this style.

For two decimals;
FLOOR(45.5454*100)/100 it will give you 45.54

For three decimals:
FLOOR(45.5454*1000)/1000 it will give you 45.545

Regards,
Essa Mughal