Return always one row (with data or empty value)

1
2
3
4
5
6
select top 1 t.Something from
(
SELECT top 1 IsNull(d.DealerName, '') as Something FROM dbo.whVsPzMaDealer d WHERE d.ProducerID = 1004
UNION All
SELECT ''
) as t