The IN operator compares a value with a list of values. It must however be used with care when we are dealing with nulls. Let’s create a table containing three city names and a null value. The goal is check whether a city is in the list or not.
Posts Tagged ‘NOT IN’
August 18, 2011 by Francois · 7 Comments
Filed under: Performance, TSQL
Social Tagging: IN • NOT IN • NULL • null values • operator
Filed under: Performance, TSQL
Social Tagging: IN • NOT IN • NULL • null values • operator
RSS