Urgent Oracle/SQL Query help

[jkl]

In Ent. Mngr, I have an Oracle server as a Linked Server.

When I execute a query such as "SELECT Total_Hours FROM Ora..Employees.TimeSheet"...

ALL records in the recordset show as 0.00


If I change the query to "SELECT Total_Hours * 1 FROM Ora..Employees.TimeSheet"...

then I get the correct values.

Any idea what's going on??

 

[jkl]

Just to add to this.

This * 1 workaround does not work, if I use any kind of join in the statement, which I need to do.