You can try something like

Select * from Test_v where key_field in
('---', 'Programmer', 'Consultant' );

This is not the best way but it will do the trick