Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    Peg City
    Posts
    5

    Cool Unanswered: How to set MONEY data-type to scale 2

    Hi All,

    Is there a way to set a MONEY datatype to a scale (decimal places) of 2?
    The default is set to 4 and I can't seem to find any resources on how to change it.

    Do I have to add a check constraint to manually round to 2 decimals??
    That seems unneccessary.... but if it is, boo-urns to sql server.

    thanks!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    alter the column to decimal(15,2)?

    Why is 4 positions a problem?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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