this is just a dummy example.. but if there is no results back for a SELECT query, is there a way to turn the result to NULL instead of empty.
select GETDATE() where 1=2
for the above query, can you display NULL and for
select GETDATE() where 1=1
display the right datetime.?