I've a value of 23.5 on a field on a table in sql server. I'm sure it's 23.5 because that's the value shown by the query analizer when I query the table.

When I retrieve this field using Sql PT, it seems that only 23.00 is returned; If I check the value of the field on the debug window or if I make a calculation involving the field, it appears to be 23.0; however, when I browse the resulting cursor, the field shows 23.5 when the field hasn't the focus and 23.0 when the focus goes to the field.

Now:
1. How can I make sure that I get 23.5 when I run a query?
2. How is it possible that Browse shows a different value depending on the field that has the focus?

TIA.