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?
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).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With