Thanks, it is a simple matter of using the below pseudocode to deal with
it:

TRUNC([field] * 100, 0) / 100

In this case the original application rounded to a 100th and the field
was ALWAYS used with two decimal places to simply sort line numbers
matched to a text field.  It would be a different matter entirely if it
were a financial field like in my 2nd example or a measurement.

Tracy Johnson
Office 1-757-766-4318
[log in to unmask] 
 

> -----Original Message-----
> From: Tony Summers [mailto:[log in to unmask]] 
> Sent: Monday, January 11, 2010 10:44 AM
> To: Johnson, Tracy; [log in to unmask]
> Subject: RE: [HP3000-L] R2 and REALs, What Do They Call it When ...?
> 
> Don't know which ODBC Driver/server you're using,  but that's 
> partly the
> point of the ODBC server - to convert proprieitary  formats into a
> platform neutral format on the client.   However,  I don't 
> know how many
> HP3000 ODBC servers can cope with the R2 format. 
> 
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of Johnson, Tracy
> Sent: 11 January 2010 15:37
> To: [log in to unmask]
> Subject: Re: [HP3000-L] R2 and REALs, What Do They Call it When ...?
> 
> We had another situation where power user was using ODBC to grab
> financial numbers and an R2 of 432.606018066406 but on the SQL side it
> would show up as an IEEE real as: 432.6059.
> 
> I understand rounding a little bit, but it seems funny that a decimal
> place of .60101 rounds to .6059.
> 
> In this case we were told that it had to do with HP's proprietary R2
> format versus Windows IEEE numbers.
> 
> The contents of this email are confidential to the intended 
> recipient and may not be disclosed. Although it is believed 
> that this email and any attachments are virus free, it is the 
> responsibility of the recipient to confirm this.
> 
> Details of Smith & Williamson group companies and Nexia Smith 
> & Williamson Audit Limited and their regulators (where 
> applicable), can be found at this URL
> 
> http://www.smith.williamson.co.uk/disclosure
> 
> 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *