Calculating a MOD 10 Check Digit


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Calculating a MOD 10 Check Digit

Hybrid View

  1. #1
    Scott Guest

    Calculating a MOD 10 Check Digit


    How do I perform a MOD calculation in SQL when the MOD operator is not available?

    Scott
    Example: 12 MOD 10 = 8

  2. #2
    Daniel Reber Guest

    Re: Calculating a MOD 10 Check Digit

    copied out of BOL:

    Arithmetic Operators
    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.

    Operator Meaning
    + (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.


    Daniel Reber
    Datamasters, Inc


    "Scott" <sremiger@pnms.com> wrote in message
    news:3e1b19fc$1@tnews.web.devx.com...
    >
    > How do I perform a MOD calculation in SQL when the MOD operator is not

    available?
    >
    > Scott
    > Example: 12 MOD 10 = 8




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center