Decimal Formatting

Hi Group,
This is my probelm, I have a SQL view which holds prices to 2 decimal place
in the Management Console they are displayed to two decimal place i.e. 1.99.
However when I run an ODBC report the values are all to mutiple decimal
places i.e. 1.9900000000000000000. I have been told there is a way to format
the vie win SQL to 2 decimal place but don't how is there a KB article or
help file that can oint me in the right direction or is there a way in the
ODBC SQL to force the formatting?
I am using SQL 2000
TIA
Formatting result sets is best handled in the client UI. If you add a
formatting function on the server side, then it's a separate function
call for every row.
-mary
On Thu, 31 May 2007 01:55:00 -0700, Jonathan
<Jonathan@.discussions.microsoft.com> wrote:

>Hi Group,
>This is my probelm, I have a SQL view which holds prices to 2 decimal place
>in the Management Console they are displayed to two decimal place i.e. 1.99.
>However when I run an ODBC report the values are all to mutiple decimal
>places i.e. 1.9900000000000000000. I have been told there is a way to format
>the vie win SQL to 2 decimal place but don't how is there a KB article or
>help file that can oint me in the right direction or is there a way in the
>ODBC SQL to force the formatting?
>I am using SQL 2000
>TIA
|||Thank you Mary I have somehow solved it by using the STR function and a
little but of luck in the client app, but thank you again for your help
Jonathan
"Mary Chipman [MSFT]" wrote:

> Formatting result sets is best handled in the client UI. If you add a
> formatting function on the server side, then it's a separate function
> call for every row.
> -mary
> On Thu, 31 May 2007 01:55:00 -0700, Jonathan
> <Jonathan@.discussions.microsoft.com> wrote:
>