Home Forums SQL Server 7,2000 T-SQL concatenate problems RE: concatenate problems
DAVNovak
Hall of Fame
Points: 3120
More actions
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