|
View previous topic :: View next topic
|
| Author |
Message |
banuradha
New User
Joined: 20 Dec 2006
Posts: 19
Location: India
|
|
|
|
Hi all,
Like we use
SELECT dept_no from department
where dept_no between 5 and 10
is that possible to check the character using between
something like the one below.
SELECT name from department
where name between like(A%) and like(E%)
Thanks,
Banu |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
HI Banu,
You will get
| Quote: |
SQLCODE = -104, ERROR: ILLEGAL SYMBOL "%". SOME SYMBOLS THAT MIGHT BE
LEGAL ARE: ) , |
|
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Banu,
I think u can use
| Code: |
SELECT name from department
where name between 'A' and 'E' |
|
|
| Back to top |
|
|
|
|
