topic Comparing 2 different data types for SQL statement in Application Development and Automation Discussions

Comparing 2 different data types for SQL statement

Former Member — Wed, 24 Oct 2007 10:35:01 GMT

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 — Wed, 24 Oct 2007 11:01:58 GMT

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 — Thu, 25 Oct 2007 02:06:09 GMT

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 — Thu, 25 Oct 2007 06:50:28 GMT

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