Hi,
you can make use of
ISNULL
function of SQL.
ISNULL
function will replace the null value with the value you specify.
refer below article for more on
ISNULL
function.
ISNULL-MSDN[
^]
SELECT ISNULL(col1, 0), ISNULL(col2, 0), ISNULL(col3, ''), ISNULL(col4, GETDATE()) FROM TableName
also, i suggest, using
"*"
in select query is not good practice. specify the column names.
hope it helps.