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