input 0001000070 is received as ' IEQ0000010'

account no. in database is stored as 0001000085 the domain is defined as characters with limit 10 .

but this value is received as input and it is displayed as IEQ0001000.

so i shifted leading zeros,

after shifting leading zeros its displayed as IEQ0001000070

anyways im using this value in a select query and query doesnt work becuse it will accept only '0001000070' .

only when i hardcode '0001000070' . in where cluase the wuery works,,even if i pass '1000070' query doesn't work..

pls note : the input is a range so i can't hard code 1 value .

any suggestions ,Thanks.