comparing character value to numeric

[mohan_subramania]

i want to compare one character field to numeric,

i got one field from some custom developed fm the field having the p_value

is of type c(30) , i want to compare this value to numeric 50000 if i use the following code it

does not give the correct value. please help

if p_value GE '50000'

[Former Member]

Hi,

data:

w_int type i,

w_char(13) type c.

w_int = w_char.

if w_int ge 50000.

ur code

endif.

[Former Member]

data: var1(30) type n.

var1 = p_value.

if var1 GE 50000.

....

[Former Member]

when you compare character value to numeric it compared from left to right not considering the length of both the variables.

Which means you will have to something like:

if p_value GE '000000000000000000000000050000'

this should give you the correct result.