How to exclude a value : I need to create a clause to restrict the data returned.

if supplier returns values 'approved' and 'in process' then do not return supplier.

Is there a way of doing this? 

thanks
 