| condition in WHERE clause [message #20320] |
Mon, 13 May 2002 10:58  |
Parag dave
Messages: 8
Registered: February 2002
|
Junior Member |
|
|
Hi,
I am trying to do a report where the user types
the manager's name ( if he wants only for that perticular manager's report) or he types 0 (character
zero) and ZZZZ for all managers.
my code looks like this.
select
---
,----
from
----
, ----
where
----
and replace(substr(t4.member_name,1,8),',','') >= upper(nvl('&&4','0')
and replace(substr(t4.member_name,1,8),',','') <= upper(nvl('&&5','ZZZZ')
I substrim the name because the longest name is 8 char.
and replace comma between lastname and name.
this gives no rows. if i do like insted of >= or <=
it gives me rows.
Please help.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
