if no rows returned sql code example

Example: tsql default value when no value returned by query

SELECT ISNULL(MIN(val), 'DEFAULT')
FROM myTable