SELECT * FROM hoge_tbl WHERE hoge_col<> ''
SELECT * FROM hoge_tbl WHERE CAST(hoge_col as VARCHAR)<> '' SELECT * FROM hoge_tbl WHERE CONVERT(VARCHAR, hoge_col)<> ''