In this article we will go through a common task of searching a table for a filtering value using various approaches, ending up with the most elegant solution using set based comparison. This way of thinking will then be explored in other common usages, such as joins and MERGE statements.