topic Re: Select code in Application Development and Automation Discussions

Select code

Former Member — Thu, 19 Oct 2006 07:02:01 GMT

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.

Re: Select code

Former Member — Thu, 19 Oct 2006 07:09:04 GMT

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

Re: Select code

Former Member — Thu, 19 Oct 2006 07:09:14 GMT

Select <something>

into <something>

from <something>

where inact like 'E%'.

Re: Select code

former_member404244 — Thu, 19 Oct 2006 07:12:28 GMT

Hi marc,

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

it will solve ur problem.

Regards,

nagaraj

Re: Select code

Former Member — Thu, 19 Oct 2006 07:19:48 GMT

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^