between operator in oracle

[hiral amit patel]

when i am searching the names in range with following query

select * from salesman where name between 'a%' and 'c%';

it does not display the names starting from c; it displays the name which starts from a and b. why it is so?

[amitpatel66]

Try this query:

[code=oracle]

select * from salesman where name LIKE 'a%' OR name LIKE 'c%';

[/code]

[hiral amit patel]

I want to search the names whose intial starts from a to c
with your answer i can find only those names which starts from a or b

[amitpatel66]

oops, silly mistake.here is the query:

[code=oracle]

select * from salesman where UPPER(SUBSTR(na me,1,1)) between 'A' and 'C';

[/code]