sql return value if no rows found code example

Example: tsql default value when no value returned by query

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