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:

Expand|Select|Wrap|Line Numbers

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

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:

Expand|Select|Wrap|Line Numbers

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

between operator in oracle

re: between operator in oracle

re: between operator in oracle

re: between operator in oracle

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about