Skip to Content
0
Former Member
Jul 10, 2006 at 12:40 PM

PROBLEM IN SELECT STATEMENT

18 Views

HI FRNDS ..

I AM HAVING SOME ERRORS IN THE WHERE CLAUSE PLZ CORRECT IT

select DOCNO into t_DOCNO from J_1IEXCHDR

where exnum = gf_text and

status ne ( 'd' and 'r' and 'b' ).

PLZ HELP ME TO COLLECT VALU OF THE STATUS FILED WHER IT IS NOT EQUAL TO D, R AND B