Professional Web Applications Themes

Limiting the currency field - Microsoft SQL / MS SQL Server

Hi, In a DB I have set a field to 'money'. When returning all rows, the field shows up to 4 decimal places. How to limit it to 2 decimal places? The design table doesn't give me a choice. TIA, Jane...

  1. #1

    Default Limiting the currency field

    Hi,
    In a DB I have set a field to 'money'.
    When returning all rows, the field shows up to 4 decimal
    places.
    How to limit it to 2 decimal places? The design table
    doesn't give me a choice.
    TIA,
    Jane
    Jane Guest

  2. #2

    Default Re: Limiting the currency field

    Hello Jane !

    When you don´t want to change the design of the table try this:

    Select CONVERT(decimal(10,2),Column)

    Jens Süßmeyer


    Jens Guest

  3. #3

    Default Re: Limiting the currency field

    > How to limit it to 2 decimal places? The design table 

    No it doesn't.

    Either use DECIMAL/NUMERIC or format the display in your application.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Jane" <com> wrote in message
    news:009101c3673a$1b486800$gbl... 


    David Guest

  4. #4

    Default Re: Limiting the currency field

    >> In a DB I have set a field [sic] to 'money'. When returning all
    rows, the field [sic] shows up to 4 decimal places. <<

    That is how this proprietary datatype is defined. It also has
    punctuation that would be part of the display functions in a properly
    designed C/S architecture. Many parts of SQL Server are still in the
    "Sybase Code Museum" that came before we has usable front end tools.
     [/ref]
    doesn't give me a choice. <<

    Start writing portable, Standard SQL and use NUMERIC(p,s) or
    DECIMAL(p,s) instead. You can adjust the scale and precision as you
    wish

    --CELKO--
    ===========================
    Please post DDL, so that people do not have to guess what the keys,
    constraints, Declarative Referential Integrity, datatypes, etc. in your
    schema are.

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Joe Guest

Similar Threads

  1. Update a currency field in Access
    By margo_ann in forum Coldfusion Database Access
    Replies: 8
    Last Post: May 26th, 02:45 AM
  2. Currency Converter
    By maflu in forum PHP Development
    Replies: 4
    Last Post: November 21st, 01:15 PM
  3. How do I view currency field in format $xx.xx
    By Terry Murray in forum ASP Database
    Replies: 2
    Last Post: November 10th, 10:01 PM
  4. currency formatting
    By ian in forum PHP Development
    Replies: 0
    Last Post: October 20th, 03:40 PM
  5. field name with special currency symbol
    By xixi in forum IBM DB2
    Replies: 0
    Last Post: September 10th, 07:51 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139