hello all,
i have a query in the following format:
select top 1
'xxx = ' + CONVERT(CHAR(23), startTime,121)
from Table1
order by startTime desc
As you can see, the result is presented with a string ("xxx") and then the value is displayed.
The problem I have is that if there are no entries in the table, nothing is returned, but I would like to have the following result in this case:
"xxx = none"
I would like the sql to do this, and not some code manipulation in my application.