-- non standard ansi

SELECT NullableColumn FROM NullOperation WHERE ISNULL(NullableColumn,'') <> '1'

OR

-- standard ansi

SELECT NullableColumn FROM NullOperation WHERE COALESCE(NullableColumn,'') <> '1'