sql server 2005空值到实际的转换

SELECT TOP 10
 Id,
 FirstName,
 COALESCE(LastName,'') AS LastName
FROM
 Person (NOLOCK)

 

select ID,name,age,sex,address, coalesce(memo,'aa') as memo from userInfo