need help with a query

[christian winborn]

So I am supposed to be deleting all records on a table "RMA" that have "Rejected" in their "Reason" Column. I first wanted to get a count of how many I had that fit the description. However, when I specify a count where Reason=Rejected I keep getting an "Empty Set" message but when I do SELECT* from RMA statement I get back many records that fit that description. SOMEONE PLEASE HELP IM A NOOOB!!Thank yall so much for any insight!! Heres what I'm running

SELECT COUNT(*)
FROM RMA
WHERE RMA.Reason="Rejected";