Select Query not working properly

[Former Member]

Hi ,

I am using below Select query getting records from table where more then one column is space.But it is  not getting any records from the table.

 
select * from ztab1

into table lt_im

FOR ALL ENTRIES IN lt_im

WHERE col1 = lt_im-col1

AND col2 = lt_im-col2

AND col3 = ' '

AND col4 = ' '

AND col5 = ' '.

If I use  col3 <> ' '

             col4 <> ' '

then it get records meeting above criterion.

Any help appericiated

Thanks,

Rek.

[Former Member]

The SELECT statement is working perfectly.

Press F1 on FOR ALL ENTRIES and you'll see that it eliminates duplicates from the returned set.

Rob

[Former Member]

Hi Rob,

Thanks for response.I found the real cause.Since col5 is date type query is failing for Col5 = ' '.

Thanks,Rek.