First Name + Middle Name + Last Name Merge With One Extra Space

 
  1. Create FUNCTION [dbo].[GetFullNameWithNoSpace]                      
  2. (                      
  3.   @First_Name varchar(50),                      
  4.   @Middle_Name varchar(50),   
  5.   @Last_Name varchar(50)  
  6. )                      
  7. RETURNS Varchar(152)                      
  8. AS                      
  9. begin                      
  10. Declare @outTime Varchar(152);                  
  11.  SELECT @outTime= REPLACE(RTRIM(COALESCE(@First_Name + ' ', '') +  
  12.                      COALESCE(@Middle_Name + ' ', '') +  
  13.                      COALESCE(@Last_Name+ ' ', '')  ), '  ', ' ')  
  14.                        
  15.                                          
  16.  RETURN  @outTime                      
  17. END  
  18. GO 
  19. SELECT dbo.[GetFullNameWithNoSpace]('ashish','','Srivastava')