Hi,
you can make use of
ISNULL
function of SQL. which will replace the DBNull value with your custom text or value (based on the datatype).
SELECT ISNULL(ColumnName, 'Your Text') AS 'Value' FROM TabelName
you can refer
ISNULL[
^] for more information.
hope it helps