Home Forums SQL Server 7,2000 T-SQL String Concatenation with Nulls and Spaces RE: String Concatenation with Nulls and Spaces

  • March 22, 2005 at 5:51 pm

    #548349

    How about this?

    select Ltrim(Isnull(first_name,'') + ' ') +

             Ltrim(Isnull(middle_name,'') + ' ') +

             Ltrim(Isnull(last_name,'') + ' ') +

             Ltrim(Isnull(suffix,'')) as FullName