Use IsNull in-built SQL-Server function
to replace column value if column value is null or it has no value assigned.
IsNull will replace column value if and only if column value is null otherwise it will take column value if it has some values.
Select isnull(MIDDLE_NAME,'NA') as MIDDLE_NAME from employee_master;
Select isnull(Budget,0.0) as Budget from project_master;
Asked In: Many Interviews |