"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:
>
> >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