Comparing 2 different data types for SQL statement

[Former Member]

I would like to ask if anyone have sample program for the following situation.

1. An internal table field – data type is DEC

2. a variable - data type of C

I need to compare 1 and 2 for my SQL statement. How can I go about it?

[Former Member]

Hi,

declare another character variable.

before comparing pass the decimal value to a character variable and compare that character value with the variable.

<b>Reward for helpful answers</b>

Satish

[Former Member]

LOOP AT ITAB_DATE.

WRITE:/ ITAB_DATE-VALID_TO.

ENDLOOP.

ITAB_DATE-VALID_TO is of data type DEC.

How can i proceed?

[Former Member]

Hi,

Move ITAB_DATE-VALID_TO to a temporary char field .

condense this temporary char field to remove empty spaces.

Then u can compare it with any character data type.

Regards,

Hemant