Re: SQL Worksheet

beerora wrote:
> Hi All,
>
> I am using Foxpro to extract data from ORACLE9i. I am connected
> through ODBC. One of the field in DB is number. When I retrieve the
> data from DB by FOXPRO the result is not ROUNDER or TRUNCATED. But the
> same query when I use in SQL Worksheet, the result is either ROUNDED or
> TRUNCATED to one decimal point.
>
> E.g., if the value is 2345678.95 then it is rounded to 2345679.0
> if the value is 234567.23 then it is truncated to 234567.30
>
> Can anyone help me why SQL worksheet behave this way?
>
> Thanks & Regards,
> beerSA

What do you want to do? Just use the appropriate function.

SELECT TRUNC(<column_name>) or SELECT ROUND(<column_name>, <places>)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org