Char to Num or Num To Char

[Former Member]

Hi Gurus,

Can any one tell the conversion from char to num or num to char in ABAP. we are using abap extractor .where we are joining num --> char Field.

select c1 c2 c3 from table x,y

where xcolumn(num) = ycolumn(char).

I got a CHAR_NUMC_CONVERSION but how i can implement in select is still a question.

Any quick suggestions would be great.

Marks will be rewarded.

[Former Member]

assign char type value in to variable of type n and compare in where statement.

[Former Member]

Can you elaborate your explanation. that would be great.

[Former Member]

you should select data from the tow tables one by one.