/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 vote234 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote185 views1 answer
We are intrested to work with your organization
SQL
0 vote214 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote203 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote203 views1 answer
Ver usuarios mysql
SQL
0 vote185 views1 answer
Mysql pv progres
SQL
1 vote190 views1 answer
Get table which have specific columns in mysql
SQL
0 vote191 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote200 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote173 views1 answer
Count column of tables psql
SQL