Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit www.joes2pros.com
Offer expires July 1, 2015
From Chapter 2.1 of Beginning SQL Joes 2 Pros (www.joes2pros.com). How to use exact criteria matches in a basic single table query in SQL server 2005 and 2008.
source