Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MOD() vs % (sql-syntax)
Message
From
03/01/2005 10:46:07
Robert Ohlicher
Zell Am See, Austria
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
MOD() vs % (sql-syntax)
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00973817
Message ID:
00973817
Views:
55
Hi all!

I've encountered a strange behaviour when using MODULO-function.

VFP8:
MOD(10-12,12) = 10

SQL:
(10-12) % 12 = -2

I need to use Modulo in my sql-syntax - what have I done wrong???

Thanks for help!
robert.oh.
Next
Reply
Map
View

Click here to load this message in the networking platform