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.

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