topic Re: Checking for Empty string in WHERE condition in Application Development and Automation Discussions

Checking for Empty string in WHERE condition

Former Member — Wed, 19 Aug 2015 08:31:23 GMT

Hi All,

I have a field with type sting in my database table, i need to get the records from database table where this string field is empty. I tried to use this string field in here condition and check if it is NULL or not. But it is not working because "Long string or text cannot be used in WHERE condition".

My Idea is to Copy this DB table into an Internal table, Loop through the internal table with where condition that string field is empty and append those records to another internal table.

Its working but i would like to know if there is any other way to do it.

My Code:


DATA: itab1 TYPE STANDARD TABLE OF DBtable,
          itab2 TYPE STANDARD TABLE OF DBtable,
          wa TYPE DBtable.
    
    SELECT * FROM DBtable INTO CORRESPONDING FIELDS OF TABLE itab1.
      
    LOOP AT itab1 INTO wa WHERE strfld is NOT INITIAL.  "strfld is string field.
     APPEND wa to itab2.
    ENDLOOP.

Thanks & regards,

NarsiReddy.

Re: Checking for Empty string in WHERE condition

former_member206394 — Wed, 19 Aug 2015 09:07:19 GMT

Dear NarsiReddy,

Greetings!

I feel using of 'Loop' on the itab might be at the cost of performance. So, better use 'DELETE' statement after 'SELECT' statement.

SELECT * FROM <dbtable> INTO TABLE <itab1>.

DELETE TABLE <itab1> WHERE strfld is initial.

with this statement execution, <itab1> will have the entries for which String Field is not blank.

Regards,

Shankar

Re: Checking for Empty string in WHERE condition

former_member206394 — Wed, 19 Aug 2015 09:07:29 GMT

Dear NarsiReddy,

Greetings!

I feel using of 'Loop' on the itab might be at the cost of performance. So, better use 'DELETE' statement after 'SELECT' statement.

SELECT * FROM <dbtable> INTO TABLE <itab1>.

DELETE TABLE <itab1> WHERE strfld is initial.

with this statement execution, <itab1> will have the entries for which String Field is not blank.

Regards,

Shankar

Re: Checking for Empty string in WHERE condition

Former Member — Wed, 19 Aug 2015 09:38:53 GMT

Hi Shankar,

Thank you, Perfect!

But a small correction, syntax is:


DELETE itab1 WHERE strfld IS INITIAL.

Kind regards,

NarsiReddy.

Re: Checking for Empty string in WHERE condition

Former Member — Wed, 19 Aug 2015 10:48:57 GMT

Hi Naris,

Hope the below condition is helpful,

LOOP AT itab1 INTO wa WHERE strfld = ' '.

Regards,

Karthik