gleznov
asked on
Is there a MOD function for SqlServer's T-SQL?
Hi,
I know Oracle uses a MOD function like Basic's to determine the remainder after a division. So 20 MOD 9 = 2 (9 goes into 20 twice for a total of 18, 20 - 18 = 2). I need to determine a remainer in a T-SQL function I'm writing for Sql Server. But there doesn't seem to be a MOD operator, or maybe it's a certain character or another name for it - I haven't found it yet though. Does anyone know of one?
JP
I know Oracle uses a MOD function like Basic's to determine the remainder after a division. So 20 MOD 9 = 2 (9 goes into 20 twice for a total of 18, 20 - 18 = 2). I need to determine a remainer in a T-SQL function I'm writing for Sql Server. But there doesn't seem to be a MOD operator, or maybe it's a certain character or another name for it - I haven't found it yet though. Does anyone know of one?
JP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
set @a=10%3