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. Thanks, Tom Hornyak
