topic Re: CONVERT a field table in a SELECT statement in Application Development and Automation Discussions

CONVERT a field table in a SELECT statement

Former Member — Mon, 09 Jun 2008 14:56:51 GMT

Hi all,

I have the follow SELECT statement:

SELECT SINGLE * FROM table1 INTO wa1

WHERE

field1 = var1;

The problem is that field1 DataType is CHAR10 and var1 DataType is I. So if field1 contains '0123' and var1 = '123' the SELECT fails.

Is there any way to consider field1 as an Integer?

Best Regards,

Raffaele

Former Member — Mon, 09 Jun 2008 14:58:59 GMT

No, but you could move var1 to a type n variable to get the leading zeros and then compare with that variable

Former Member — Mon, 09 Jun 2008 15:03:33 GMT

hi,

do this way ..Convert it to char data type


data : var1 like table1-field1 value '0123'.

SELECT SINGLE * FROM table1 INTO wa1
WHERE
field1 = var1.

Former Member — Mon, 09 Jun 2008 15:28:25 GMT

No, but you could move var1 to a type n variable to get the leading zeros and then compare with that variable

It doesn't work because I don't know how many zeros are in the field1.

Best Regards,

Raffaele

Former Member — Mon, 09 Jun 2008 15:44:22 GMT

use the FM : CONVERSION_EXIT_ALPHA_OUTPUT to quit the zeros of any variable.

example

if u have 000945

after call FM u obtain only 945