If You have say table "Employee" and column Emp_Name(that contains , NULL values)

Then.

Example:

Update Employee

SET Emp_Name = ISNULL(Emp_Name , ' ')

where <condition>.....................(If required, or all wherever there are NULL value in Emp_Name column,

those records will get replaced by blank value(Means nothing))