从结果集中删除空白行

I have a query like this:

我有这样的查询:

select
    '0' as F_Stand_Code,
    '' as F_Stand_Desc
union all
select
    F_Stand,
    F_Stand
from T_ExhibitorLocation
where F_Site ='DIP2'
  and F_Bld = 'Le Meridien'
  and F_Hall = 'Great Ballroom'
  and F_ExhibitionCode='10991'
select