GROUP BY v DISTINCT (group by wins!)

re: GROUP BY v DISTINCT (group by wins!)

Rob Farley — Tue, 05 Jun 2007 11:46:00 GMT

COALESCE only helps handle the situations where the string is null. It doesn't actually assist with the concatenation process itself.

Coalesce is not the answer to string concatentation in T-SQL — Tue, 05 Jun 2007 11:35:45 GMT

Rob, If u do not wants to use COALESCE function in ur T-SQL, then u can use CASE statements for String concatenation.

What say?

Mahesh

Rob Farley — Sun, 08 Apr 2007 03:56:26 GMT

I've seen many posts over the years about using the COALESCE function to get string concatenation working