Home Forums SQL Server 7,2000 T-SQL concatenate problems RE: concatenate problems

  • June 12, 2003 at 4:54 pm

    #461179

    Another way is

    SELECT

    CASE WHEN col2 IS NULL THEN col1

    ELSE col1+ ', ' +col2 END

    FROM ....