Results 1 to 5 of 5

Thread: Currency

  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Red face Unanswered: Currency

    Hello I am a newbe to sql and i am shure my problem is simple but hope somone can help.

    My Total comes out like $20.00 and i want it to come out like 20.00

    Simple but frustraiting

    Any help apprieciated

    Colin

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    This is a formatting issue, and thus does not fall under the scope of the SQL Engine. What application/interface are you using to display the value, and what datatype are you using?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    Thanks for your reply

    The data type is set to money and its a web site built with Dreamweaver and it outputs in explorer if thats what you mean.

    Thanks again

    Colin

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The SQL Money data type just defines how the data is stored in SQL Server. Four significant digits held to the right of the decimal point. It has nothing to do with how it is formatted.

    You need to check Dream Weaver's help file for assistance, though Dream Weaver may just check your system defaults.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Mar 2004
    Posts
    4
    Thanks again I will do that, but I think I have been here befor.

    Best regards,

    Colin

Posting Permissions

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