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

  • June 12, 2003 at 4:49 pm

    #461176

    Try moving the ',' into the ISNULL function.

    SELECT Col1 + ISNULL(', ' + Col2, '')

    This way the comma will show up only when you have a non null value in Col2