Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 08, 2008 at 09:02 PM

    What do you mean by input? someone enters the number?

    If it's a range use IN. It should work

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2008 at 09:13 PM

    how do you define the select option. show your declaration and related code...?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      select options : account for tablename-fieldaccount.

      i'm using this value in select query.

      select * from table into itab where fieldaccount IN account.

      here as i said earlier in table ,domain is char with limit 10 .

  • avatar image
    Former Member
    Oct 08, 2008 at 09:48 PM

    It looks like you are treating a SELECT-OPTION like a PARAMETER in a WHERE clause of a SELECT statement.

    Rob

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      At the top of the thread there is a link that allows you to close the thread (mark as answered - even though it isn't). You can also assign p0ints to any answer that you feel helped.

      Rob