CODE EXAMPLE FOR SQL

tsql default value when no value returned by query

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