sql function returns default value when no records are returned code example
Example: tsql default value when no value returned by query
SELECT ISNULL(MIN(val), 'DEFAULT')
FROM myTable
SELECT ISNULL(MIN(val), 'DEFAULT')
FROM myTable