Assign default value to a datacolumn in a select statement

select col1 (some default value) from tblname;

SELECT COALESCE(column_name, default_value) FROM table_name;

select
  isnull(col1, defaultvalue)
from
  tblname;