ISNULL ( check_expression , replacement_value ) Replaces NULL with the specified replacement value. The value of check_expression is returned if it is not NULL; otherwise, replacement_value is returned after it is implicitly converted to the type of check_expression, if the types are different. Example: create table Tab(id int,name char(10)) insert into Tab values(1,'Vikas') insert into Tab values(2,null) insert into Tab values(3,null) insert into Tab values(4,'Arun') select * from Tab select id,isnull(name,'No data') as name from Tab