2007 Mar 21 11:16 AM
Hallow
I wont to delete from my internal table value with persg <> 6 or 7 or 8
I try like that but it delete data in my table with persg 6 7
How I can delete all the row in my table with 6, 7,8 in persg
This is my trying
and its not working
DELETE person_tab WHERE ( persg <> 6 OR persg <> 7 OR persg <> 8 ).
regards
2007 Mar 21 11:24 AM
Try this,
DELETE person_tab WHERE ( persg <> 6 AND persg <> 7 AND persg <> 8 ).
Hallow
I wont to delete from my internal table value with persg <> 6 or 7 or 8
I try like that but it delete data in my table with persg 6 7
How I can delete all the row in my table with 6, 7,8 in persg
This is my trying
and its not working
DELETE person_tab WHERE ( persg <> 6 OR persg <> 7 OR persg <> 8 ).
regards
2007 Mar 21 11:22 AM
hi,
do this way
DELETE person_tab WHERE ( persg <>' 6' OR persg <> '7' OR persg <>' 8' ).Regards,
Santosh
2007 Mar 21 11:22 AM
DELETE person_tab WHERE ( persg <> 6 AND persg AND 7 OR persg AND 8 )
is the correct one...
reward if helpful...
2007 Mar 21 11:23 AM
Try this..
DELETE person_tab WHERE ( persg <> '6' OR persg <> '7' OR persg <> '8' ).
Reward points if useful...
Cheers,
Sam
2007 Mar 21 11:24 AM
Try this,
DELETE person_tab WHERE ( persg <> 6 AND persg <> 7 AND persg <> 8 ).
2007 Mar 21 11:24 AM
Hi,
write:
DELETE person_tab WHERE ( persg >= 6 and persg <= 8 )
you can put them in range and write:
DELETE person_tab WHERE persg in r_numbers.
or write 3 times:
DELETE person_tab WHERE persg = 6.
DELETE person_tab WHERE persg = 7.
DELETE person_tab WHERE persg = 8.
regards,
Anji