This article is tagged with:
Tsql default value when no value returned by query
and mysql
tsql default value when no value returned by query
SELECT ISNULL(MIN(val), 'DEFAULT')
FROM myTable