topic Re: comparing character value to numeric in Application Development and Automation Discussions

comparing character value to numeric

mohan_subramania — Wed, 21 May 2008 13:14:50 GMT

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 — Wed, 21 May 2008 13:18:14 GMT

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 — Wed, 21 May 2008 13:19:14 GMT

data: var1(30) type n.

var1 = p_value.

if var1 GE 50000.

....

Former Member — Wed, 21 May 2008 13:20:08 GMT

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.