Between & And Clarification

591995Aug 8 2007 — edited Aug 24 2007

select ename from emp where ename between 'James' and 'Ward' order by ename

select ename from emp where ename between 'JAMES' and 'WARD' order by ename

select ename from emp where ename between 'J' and 'W' order by ename

Each of these queries retreive different no. of rows. Can anybody clear this out?

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Sep 21 2007

Added on Aug 8 2007

27 comments

4,192 views