Calculating a MOD 10 Check Digit
How do I perform a MOD calculation in SQL when the MOD operator is not available?
Example: 12 MOD 10 = 8
Re: Calculating a MOD 10 Check Digit
copied out of BOL:
Arithmetic operators perform mathematical operations on two expressions of
any of the data types of the numeric data type category. For more
information about data type categories, see Transact-SQL Syntax Conventions.
+ (Add) Addition.
- (Subtract) Subtraction.
* (Multiply) Multiplication.
/ (Divide) Division.
% (Modulo) Returns the integer remainder of a division. For example,
12 % 5 = 2 because the remainder of 12 divided by 5 is 2.
"Scott" <firstname.lastname@example.org> wrote in message
> How do I perform a MOD calculation in SQL when the MOD operator is not
> Example: 12 MOD 10 = 8
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center