Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unanswered: Decimals in view

    Hello,

    I want a view to always present my numeric fields with 2 decimals. In my table I have the following values in field "amount" (numeric(18,2))

    181.25
    176.5
    170

    I want the view to show
    181.25
    176.50
    170.00

    I have tried Cast but that doesn't seem to do the job.

    Help!

    Rolf

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Note that this is very poor practice to use server side code to format data. Formatting ought to be done by the client.

    With that said, you can use the Str() function to format it as a string.

    -PatP

Posting Permissions

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