I have a table which has a column defined as Integer and with NULLS. The existing code checks whether this column = 0 or column >0 . If yes, it inserts into another table. Now, will the NULLS be inserted too ?
I tried this and as per my test, teh NULLS will not be inserted . But I would like a confirmation from teh experts or a reference which explains handling of NULLS.