Q&A about the site for enthusiasts and power users of Windows Phone OS
declare @int1 int = null declare @int2 int = 2 declare @int3 int = 3 declare @int4 int = null declare @int5 int = null select * from (values(1),(2),(3),(4),(5)) as T(N) where N NOT IN (@int1, @int2, @int3, @int4, @int5)