select * from TABLO Where ID not in(select ID from TABLO Where durum Like '%7%')

Bi de bunu dene