SQL Server COALESCE()函数创新应用

CREATE FUNCTION WholeName 
(
      -- Add the parameters for the function here
      @first varchar(50),
      @middle varchar(50),
      @last varchar(50)

)
RETURNS varchar(50)
AS

BEGIN
      -- Declare the return variable here
      DECLARE @Result varchar(50)


      -- Add the T-SQL statements to compute the return value here
      SELECT @Result = @first +' '+COALESCE(@middle,'')+' '+COALESCE(@last,'')


      -- Return the result of the function
      RETURN @Result



END

GO