sql server 3a concatinate column value without trailing or leading comma

Solutions on MaxInterview for sql server 3a concatinate column value without trailing or leading comma by the best coders in the world

Search
showing results for - "sql server 3a concatinate column value without trailing or leading comma"
Margot
08 Aug 2020
1DECLARE @x TABLE(Id INT, City VARCHAR(32), Province VARCHAR(32), Country VARCHAR(32));
2
3INSERT @x(Id, City, Province, Country) VALUES
4(1,'Vancouver','British Columbia','Canada'),
5(2,'New York' , null             , null   ),
6(3, null      ,'Adama'           , null   ),
7(4, null      , null             ,'France'),
8(5,'Winnepeg' ,'Manitoba'        , null   ),
9(6, null      ,'Quebec'          ,'Canada'),
10(7,'Seattle'  , null             ,'USA'   );
11
12SELECT Id, Location = STUFF(
13      COALESCE(', ' + RTRIM(City),     '') 
14    + COALESCE(', ' + RTRIM(Province), '') 
15    + COALESCE(', ' + RTRIM(Country),  '')
16    , 1, 2, '')
17  FROM @x;
source
similar questions
sql server 3a how to concatenate column data using commaoracle alter table add column not nullstring concatenation sql serverreplace null with 0 in sqlsql server concat nullget value comma separated sql serversqlserver 3a can we select from comma seperated string variable valuesearch from comma separated values in sql serveradd new column not null sql serversql remove leading spacesconcat two columns in sql serversql find leading spaceconcatenate columns in tablesql server concat string and intsql server 3a select column values as comma separated stringsql column values comma separatedsql add column after anothersql join on comma separated fieldadd 10 to all numbers in a column sqlsql server microsoft how to add column at specific location in tabletrim leading zeros in sqlsql concat string with column valuesql print concatenate
queries leading to this page
sql concatenate columns comma separatedsql server 3a concatinate column value without trailing or leading comma