sql returns deafult value if none is found code example

Example: tsql default value when no value returned by query

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