Select code

[Former Member]

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.

[Former Member]

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

[Former Member]

Select <something>

into <something>

from <something>

where inact like 'E%'.

[former_member404244]

Hi marc,

Select .....where inact like 'E%'.

it will solve ur problem.

Regards,

nagaraj

[Former Member]

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^