• select * from ##TableNulls where col2 is not null

    will give out the expected results at fist sight

    Thank you for the question

    Igor Micev,My blog: www.igormicev.com