Re: SQR Numerical Compare Issue

[Betty McClellan <mccle018@NGWMAIL1.NDIS.UMN.EDU>]

I've had the same problem in some of my sqrs.  SQR has a floating point decimal bug that causes this.  If I remember correctly, this problem can appear if you convert the variable from a character using to_number.  If you do a display of your variables before you do the compare, you'll see that one of them has a digit other than 0 somewhere in the number.  I've used the 'number.sqc' from PeopleSoft and a format-number to get around it.