Tuesday, April 12, 2011

Alternate of ISNULL command

SET CONCAT_NULL_YIELDS_NULL ON; GO select EMPID, 'F'+FirstName , 'L'+LastName from EMP GO SET CONCAT_NULL_YIELDS_NULL OFF; select EMPID, 'F'+FirstName , 'L'+LastName from EMP