Re: SQR not recognizing number

[Antonio Guiza <aguiza@PCC.EDU>]

My guess.  You're dealing with strings not numbers

list of strings unsorted:
2500
50
25
24

List of strings sorted:
24
25
2500   <--  It is truly less than string '50'
50

-ag

At 10:47 AM 11/30/01 -0600, you wrote:
>SQR 6.1.3
>Oracle 8.5
>
>I am having a problem with SQR not recognizing a number as follows:
>
>Here is the script:
>
>if eq8 >='50'
>do print
>end-if
>
>The value of eq8 is 2500, however the print procedure does not execute
>unless my greater than figure is 25 or less.
>So when I use  (if eq8 >= '25') or I use (if eq8>= '24') the print procedure
>executes.
>
>By the way, I have verified that the figure is actually 2500 by selecting
>the row where value = '2500'.
>
>Any idea what could be going on here??
>
>
>Thanks
>
>
>Bob H


---------------------------------------------------------------------------------------------------
Antonio G. Guiza                                        mailto:aguiza@pcc.edu
Programmer/Analyst                                                (503)
977-4395
Portland Community College  SY CC-224             fax (503) 977-4987
ITS Systems Development                                 http://www.pcc.edu
---------------------------------------------------------------------------------------------------