Results 1 to 2 of 2

Thread: substitute for Mod Function

  1. #1
    Join Date
    Mar 2003
    Posts
    16

    substitute for Mod Function

    What s the substitute for Mod Function In Sql server

    mod function in access returns the remainder

  2. #2
    Join Date
    Feb 2003
    Posts
    102

    modulo

    Use %

    SELECT 22 % 10

    gives


    -----------
    2

    (1 row(s) affected)

    Mod is short for modulo

    HTH,

    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •