Peter
I'm not
aware of MOD being an integral part of an SQL statement (I may be wrong).
The general MOD OPERATOR yields the remainder from integer division; hence 10
MOD 8 = 2, 10 MOD 5 = 0. You can use any functions/maths operators in
SQL, so isn't this just a means of filtering the data? Typically used to
get, say, all the even-numbered fields. e.g.
Select
...
where
MemberNo MOD 2 = 0
HTH
Terry
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Hatton
Sent: 17 March 2006 08:47
To: Terry McDonnell
Subject: [MI-L] MOD SQL FUNCTION
Hi all,
can anyone tell me what th "mod " function in an SQL statement does / means
?
Regards
Peter
Peter HATTON
GIS Officer
Greater Taree City Council
2 Pulteney Street TAREE
2430
phone 02 6592
5227
e-mail [EMAIL PROTECTED] gov.au
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council.
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
