Advertisement

05.16.2008 at 09:20AM PDT, ID: 23408844 | Points: 500
[x]
Attachment Details

Concatenate multiple rows

Asked by colechr in SQL Query Syntax

Tags: Sybase SQL

Hi,
I am trying to concatenate multiple rows ina table, e,g my current table looks like this;

ID             Citycode
A123       LN
B123       TK

I would like to concatenate the Citycode so that the table looks like below;
A123   LNTK
B123   LNTK

I'm not quite sure of the best way to do this. Please note the citycode will not always be 'Ln' or 'TK' . Start Free Trial
[+][-]05.16.2008 at 10:58AM PDT, ID: 21584989

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 11:09AM PDT, ID: 21585069

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.25.2008 at 11:44AM PDT, ID: 21643376

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.09.2008 at 06:43AM PDT, ID: 22196261

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628