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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL