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

home

app

help

profile

we are a community of more than 2 million smartest coders

registration for

employee referral programs

are now open

get referred to google, amazon, flipkart and more

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 comma oracle alter table add column not null string concatenation sql server replace null with 0 in sql sql server concat null get value comma separated sql server sqlserver 3a can we select from comma seperated string variable value search from comma separated values in sql server add new column not null sql server sql remove leading spaces concat two columns in sql server sql find leading space concatenate columns in table sql server concat string and int sql server 3a select column values as comma separated string sql column values comma separated sql add column after another sql join on comma separated field add 10 to all numbers in a column sql sql server microsoft how to add column at specific location in table trim leading zeros in sql sql concat string with column value sql print concatenate

queries leading to this page

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