Results 1 to 4 of 4

Thread: Inserting a 0

  1. #1
    Join Date
    Oct 2003
    Posts
    16

    Unanswered: Inserting a 0

    Hi,
    Im having trouble with the money data type, for instance I have a column that calculates a price but it will output the price as 470.2 instead of 470.20 which is how I want it displayed on a web page.

    Anyone know how to automatically insert a zero on the end of the price?

    THanks

  2. #2
    Join Date
    Oct 2003
    Posts
    16
    Noone knows how to insert zeros on the end of numbers??

  3. #3
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    I'm gettin '470.2000'
    from this simple query I ran from query analyser
    Code:
    declare @dollar as money
    set @dollar=470.2
    select @dollar
    I can't understand why your only getting 470.2. Maybe you can write your calculation query for us to figure?
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  4. #4
    Join Date
    Oct 2003
    Posts
    16
    I figured it out but thanks anyhow : )

Posting Permissions

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