select * from table where id <> '' select * from table where id !=''
select * from table where id='' select * from table where ISNULL(id)