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.