Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Simple SQL Query

    I have a SQL query that returns a number that looks like 22.917411. I want to display this as 22.91. How do i do this in SQL 2000. If i have a query that returns 22.9100000, how do i display 22.91.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Display issues should really be handled by the client, not the server.

    You'd format the string quite differently in the US than in parts of Europe. The data should be consistent at the server, regardless of where the client sits and how it shows things!

    -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
  •