Professional Web Applications Themes

showing numbers after the decimal point.... - Microsoft SQL / MS SQL Server

Use Convert(Decimal(5,2),value). "Post Mortem" <net.il> wrote in message news:phx.gbl...  of ...

  1. #1

    Default Re: showing numbers after the decimal point....

    Use Convert(Decimal(5,2),value).

    "Post Mortem" <net.il> wrote in message
    news:phx.gbl... 
    of 


    msnews.microsoft.com Guest

  2. #2

    Default showing numbers after the decimal point....

    Hi all.....
    what function or special way is there to determine how many numbers i want
    to show after a decimal point?
    For instance i want to use this format ###.##
    i saw ppl writing about a function?! called DECIMAL....but my SQL doesnt
    recognize that....and format doesnt work too.....
    all i want to do is to show any number (be it int or decimal) with a max of
    2 trailing numbers behind the decimal point
    can someone plz help
    thanx alot
    Post mortem


    Post Guest

  3. #3

    Default Re: showing numbers after the decimal point....

    Are you using Microsoft SQL Server or mySQL?

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  4. #4

    Default Re: showing numbers after the decimal point....

    Sql Server.....not mySql :)

    "Anith Sen" <com> wrote in message
    news:phx.gbl... 


    Post Guest

  5. #5

    Default Re: showing numbers after the decimal point....

    i tried the convert to decimal
    Convert(Decimal(5,2),value)......and for some reason.....i keep getting my
    results in integers......
    for instance 125...instead of 125.00
    any ideas?



    "msnews.microsoft.com" <com> wrote in message
    news:phx.gbl... [/ref]
    want 
    > of 
    >
    >[/ref]


    Post Guest

Similar Threads

  1. #39305 [NEW]: Use of decimal point in different countries
    By steinm@php.net in forum PHP Bugs
    Replies: 0
    Last Post: October 30th, 11:16 AM
  2. db doesn't accept decimal numbers
    By skydiver_jim in forum Coldfusion Database Access
    Replies: 2
    Last Post: August 15th, 01:08 PM
  3. decimal point or comma
    By DeeWee in forum Informix
    Replies: 5
    Last Post: September 22nd, 08:54 AM
  4. Rounding up anything past the decimal point sprintf
    By Blnukem in forum PERL Miscellaneous
    Replies: 9
    Last Post: September 4th, 10:39 PM
  5. losing the decimal point in a string
    By Shane in forum Macromedia Director Lingo
    Replies: 0
    Last Post: July 28th, 08:28 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