SQL IN clause which is guaranteed to evaluate to false

Question

Is there any value which I can place in a SQL IN clause which will guarantee that the clause will evaluate to false?

SELECT *
FROM Products
WHERE ProductID IN (???)

Is there anything I could replace ??? with to guarantee no rows will be returned?

Answer 1

Replace with NULL. There is no better guarantee!

Because no other value can equal to NULL, even NULL itself.

And this is kinda universal value for any type(as @zohar-peled mentioned).

Answer 2

Put some initially invalid ProductID, e.g. -1.

SELECT *
FROM Products
WHERE ProductID IN (-1)

Answer 3

Use NULL

SELECT *
FROM Products
WHERE ProductID IN (NULL)

As this will return nothing

Answer 4

Try

SELECT *
FROM Products
WHERE ProductID IN (0)

I'm pretty sure that you don`t have product with ID=0

That will return false.

Answer 5

SELECT *
FROM Products
WHERE ProductID IN (SELECT '')

Another possible way.