SQ01 - remove leading zeros at selection screen

[Former Member]

Hi,

I have an infoSet with tables AUSP and CABN. When I create a query using this InfoSet, I need to enter leading zeroes in the field I'm using at the selection-screen (AUSP-ATWRT). I'm only after the last 6 digits as this is my material number. If I enter all the leading zeroes, the query works just fine, but for an end-user this is not very convenient.

Does anybody know if this can be done in the query or in the InfoSet, or do I need some programming skills here?

Thanks in advance:)

Br,

Lars

Edited by: Lars Hesleskaug on Apr 14, 2010 11:38 AM

[iklovski · Accepted solution]

Hi Lars,

You have to create your own field in the Infoset converting the real one to numeric value, so the leading zeros will be removed. The search then will be working based on this new field.

Regards,

Eli