如何查询数据库中某个字段不为空的数据

select I_NAME from TABLE where I_NAME is not null and I_NAME<>'';