What is the MOD function, and what would I use it for?
MOD (modulus) returns the remainder of a division of the first operand by the second. It is very useful to extract part of a numeric field, and used in conjunction with subtraction and division, the MOD operation is like a numeric equivalent to the substring function. This example shows how to use MOD to extract parts of a MMDDYY numeric date.
