/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 vote228 views2 answers
How to update the multiple rows in sql
SQL
0 vote234 views1 answer
Pl sql constraint user function
SQL
0 vote218 views1 answer
Mysql regex exact match
SQL
0 vote233 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote236 views1 answer
Cross apply top for each row t1
SQL
0 vote232 views1 answer
Acual month sql
SQL
0 vote244 views1 answer
Copy data from one postgres container to another
SQL
0 vote254 views1 answer
Mysql user set plugin
SQL
0 vote239 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
3 votes267 views2 answers
Check data in table mysql
SQL