T-SQL not in encounters null implied trap

There are two T-SQL below, at first glance thought to be equivalent, but actually not

                         select  orderid1, Localcost,                                Supplygoodsname, Buyersgoodsid, Jsitid, Gsitid from  csc_  Result with  (NOLOCK) where  [level ] > 0  and  orderid1 like   ' 618464266 % '  and  (supplygoodsid  Not  in  (1085317 , 1112957 )) 

                         SELECTORDERID1, Localcost, Supplygoodsname, Buyersgoodsid, Jsitid, Gsit Id fromCsc_result with(NOLOCK)WHERE[ Level] >0                                     andOrderid1 like ' 618464266% '                                     and(Supplygoodsid not inch(1085317,1112957)ORSupplygoodsid is NULL)

Visible not in does not exclude null values

T-SQL not in encounters null implied trap