select statment

Hi..

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.