Hi all,
Can anyone suggest a way to retrieve more than two digits to the right of
the decimal point in QA?
Query is fine in OSQL, 0.00 in QA. Any ideas of why and how to get correct
values from the database?
ie;
select cast(1/50 as numeric(20,20))
Results
-----------------------------------------------------
0.00

(1 row(s) affected)
is not what I want.
_____________________________________________________________________
1> select cast(1/50 as numeric(20,20))
2> go

----------------------
.00000000000000000000
(1 row affected)
is what I want.
How can I do this in QA?

Many TIA's

-- chip
MS Sql Server LazyDBA home page