SQLite+Question+-+SELECT+WHERE+IN

Here's a pretty dumb question. Why will the following extremely simple query not return the desired results? I'm trying to see the sentence templates just for the birth, death, marriage, and burial facts. code SELECT FT.FactTypeID, FT.Name, FT.Sentence FROM FactTypeTable AS FT WHERE FT.Name IN ('Birth','Death','Marriage','Burial'); code To get the desired results, I instead do something like the following. code SELECT FT.FactTypeID, FT.Name, FT.Sentence FROM FactTypeTable AS FT WHERE FT.Name IN ('Birth','Death','Marriage','Burial') AND FT.Name NOT LIKE '%Bann' AND FT.Name NOT LIKE '%Contract' AND FT.Name NOT LIKE '%License' AND FT.Name NOT LIKE '%Settlement'; code In effect, the IN operator is acting like it's using LIKE rather than =. So it's picking fact names I don't want such as Marriage Bann, etc.

Jerry