sql query to show all records except for certain records

Question

i have an ms-access table

TableA

MSN   PR
11    -
13    A
12    Dead
14    B
15    C

How can i write an sql query to remove records in "-" and "Dead" occurances in PR collumn. so that query result should be

MSN  PR
13   A
14   B
15   C

any help appreciated

Answer 1

To exclude the rows from a selection:

select *
from TableA
where PR not in ('-','Dead')

Or to permanently remove them:

delete
from TableA
where PR not in ('-','Dead')

Answer 2

select msn, pr from tableA where pr not in ('_', 'Dead')

Answer 3

The answer essentially is 'create a search condition by adding a WHERE clause to your query' i.e. you clearly know next to nothing about SQL so an online tutorial aimed a beginners would be more appropriate than a Q&A site.