How do I check if an integer is null in SQL?

Primitive types such as integers and Booleans cannot generally be null , but the corresponding nullable types (nullable integer and nullable Boolean, respectively) can also assume the NULL value.

So, you can do the check with 0 instead. If you want to do the null check. Use Integer wrapper for that.

The IS NULL condition is used in SQL to test for a NULL value. It returns TRUE if a NULL value is found, otherwise it returns FALSE. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement.

So, you can do the check with 0 instead. If you want to do the null check. Use Integer wrapper for that.