Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    202

    Unanswered: How to Change 200 to 2.00

    Hi,

    Can anyone help me on this problem please?
    When i use sql statement to pull out data, one of the fields will pull out data like 200 or 300 or sumthing like that.
    But now i need to pull out the data as 2.00 instead of 200.
    How do i do that?
    Thanx

  2. #2
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    Select Cast(200/100 As Decimal(38, 2))

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The simplest way to turn 200 into 2.00 is to invest it in AT&T stock.

    Barring that, why don't you just divide by 100.00? Note that you will need to include the decimal point and placeholders in your divisor so that the result will include 2 digits of precision.
    If it's not practically useful, then it's practically useless.

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

Posting Permissions

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