I am a perl and DBI novice, so pease forgive the possible stupid question.
I am running SQL server and have float column ( real(8) ) defined. The
problem is the rounding between a select statement in the query analyzer and
DBI. A user enters a value like 0.166, when doing a select in Query
Analyzer, they see 0.166. Of course, in DBI they see 0.16599999. They enter
0.002646 and see -2.6459999E-3, etc. Is there an easy way to get
perl's/DBI's display format/precision to match SQL Query Analyzer? Note,
changing the DB Schema is NOT feasible.