10-19-2006 8:02 AM
Hi all,
In my select statement my condition is where Status Inactive (INACT) is blank and Status is 'E*'.
Such that 'E*' INACT field contains all field that starts with letter E.
How can I code this?
Thank you.
10-19-2006 8:09 AM
Hi Marc
Please do it this way.
<b>where status = ' '</b> "Inactive
or <b>status like 'E%'</b>. "E* i.e status which starts with E.
Above where condition is to extract records where status is inactive or status has values which start with E.
Kind Regards
Eswar
10-19-2006 8:09 AM
Hi Marc
Please do it this way.
<b>where status = ' '</b> "Inactive
or <b>status like 'E%'</b>. "E* i.e status which starts with E.
Above where condition is to extract records where status is inactive or status has values which start with E.
Kind Regards
Eswar
10-19-2006 8:09 AM
Select <something>
into <something>
from <something>
where inact like 'E%'.
10-19-2006 8:12 AM
Hi marc,
Select .....where inact like 'E%'.
it will solve ur problem.
Regards,
nagaraj
10-19-2006 8:19 AM
hi
good
here you have not mentioned from which table you r selecting the data and what is your internal table name so it is quite tough you give you the exact answer
you can try this wa
select incat and status field name from tablename into correcsponding fields of table internal table name where
INACT = SPACE AND status field name = 'E*'.
thanks
mrutyun^