Skip to Content
author's profile photo Former Member
Former Member

Select code

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 07: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 07:09 AM

    Select <something>

    into <something>

    from <something>

    where inact like 'E%'.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2006 at 07:12 AM

    Hi marc,

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

    it will solve ur problem.

    Regards,

    nagaraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 07: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^

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.