Re: SQR not recognizing number

[Rachael Beatty <Rachael_Beatty@HILTON.COM>]

In sqr, the value 2500 is different from '2500'.  Usually within quotes, it
is a string and this is usually left justified instead of right justified,
so '50' would be greater than '2500'.

Try using a numeric variable (#eq8) and changing the statement to eq8 >=
2500.

Hope that helps.

Rachael

> -----Original Message-----
> From:   "Hallmark, Robert J" <robert.j.hallmark@LMCO.COM>@INTERNET
> Sent:   Friday, November 30, 2001 8:48 AM
> To:     SQR-USERS@list.iex.net
> Subject:     SQR not recognizing number
>
>
> 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
>

(See attached file: C.DTF)

C.DTF