I am doing a select statement on a database table based on a material number from a legacy file.
The MATNR in SAP is char 18. If the legacy file material number has complete 18 chars like '000000000000100010' , then the select works fine.
but if the legacy file has just '100010' for material number without leading zero's then the select fails.
any idea how to approach this issue .
Thanks and will reward helpful answers.