Skip to Content
0
Former Member
May 27, 2008 at 03:25 PM

Doubt in "Select between" statement

1785 Views

Hi All,

I need to select all the userid's between 'A' to 'Z' ( or 'A* to B' ) ; where 'A' , 'Z*' would be input on the selection screen.

when I tried :

select bname

from user_addr

into <<internal table>>

where bname between 'A' and 'Z'.

It gave me all the user id's starting with 'A*' but didn't proceed further to B,C,D,...Z.

Any possible solution. It is URGENT.

Good reward points would be awarded to correct answers.

Thanks,

Vishal.