IsNull

The ISNULL function checks an expression for a NULL value and replaces it with a specified replacement value.

select birthdate,
isnull (birthdate,from '01/04/12')as and newdate
from employees
where employeeid =10

see more information plz visit