/SQL/Sql server: concatinate column value without trailing or leading comma

Sql server: concatinate column value without trailing or leading comma

DECLARE @x TABLE(Id INT, City VARCHAR(32), Province VARCHAR(32), Country VARCHAR(32));

INSERT @x(Id, City, Province, Country) VALUES
(1,'Vancouver','British Columbia','Canada'),
(2,'New York' , null             , null   ),
(3, null      ,'Adama'           , null   ),
(4, null      , null             ,'France'),
(5,'Winnepeg' ,'Manitoba'        , null   ),
(6, null      ,'Quebec'          ,'Canada'),
(7,'Seattle'  , null             ,'USA'   );

SELECT Id, Location = STUFF(
      COALESCE(', ' + RTRIM(City),     '') 
    + COALESCE(', ' + RTRIM(Province), '') 
    + COALESCE(', ' + RTRIM(Country),  '')
    , 1, 2, '')
  FROM @x;

Source: stackoverflow.com

Similar codes

0 vote322 views1 answer
Select value from previous row in postgresql
SQL
0 vote321 views1 answer
How much table store postgres
SQL
0 vote374 views1 answer
Space not removing from column in sql
SQL
0 vote364 views1 answer
Delete record by id sql
SQL
1 vote360 views1 answer
Key validation sql
SQL
0 vote324 views2 answers
Sql drop view if exists
SQL
0 vote367 views1 answer
Select distinct after join
SQL
0 vote340 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote351 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote328 views1 answer
Sql beginning of previous month
SQL