comparing numbers

[Former Member]

The numbers i want to compare are in a database. i am using the select statement (ie) select * from gfffff

where (fieldname) = jhkll-(fieldname).

the other number has leading zeros but the otherone does not have. the data type of the numbers is c.

[Former Member]

Hi Tendai,

You can do this before the select statement

Use the Fm " Conversion_EXIT_ALPHA_OUTPUT".

Exporting

Input = ws_num "(00000000000001)

Importing

Output = ws_num "(1).

Use this to chk in the SELECT stmt

Reward if useful.

Regards,

Chitra

[Former Member]

you can use CONVERTION_EXIT_ALPHA_INPUT to add leading zeros but try below logic.

In select statement we need to chnage the other component as its type

For example

select * from gfffff

where (fieldname) = jhkll-(fieldname).

suppose fieldname = type c

then

loop at jhkll

and store fieldname into some local table where fieldname type also C

endloop

then

select * from gfffff

where (fieldname) = locall-(fieldname).

Rewards if useful...............

Minal Nampalliwar

[Former Member]

select * from gfffff
where (fieldname) = jhkll-(fieldname).

suppose fieldname has 3 leading zeros, in that case, jhkll-(fieldname) in a local variable and concatenate 3 leading zeros before comperation. Ex:

concatenate '000'  jhkll-(fieldname) to lv1. 
select * from gfffff
where (fieldname) = lv1.

If jhkll-(fieldname) has 3 leading zeros then,

select * from gfffff
where (fieldname) = jhkll-(fieldname)+3.

[Former Member]

This message was moderated.

[Former Member]

Moderator message - Please search before asking - post locked Rob