Concatination - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Concatination

Author

Topic

apantig
Posting Yak Master

104 Posts

Posted - 2004-03-18 : 20:01:25

Hi,

I have a problem on how to Concatinate charater data with 2 tables.
Example:


(Table1)
Column1
-------
Mary said,

(Table2)

Remarks
-------
The
Quick
Brown
Fox
Jumps
Over
The
Lazy
Dog

The result should be:

Mary said, The Quick Brown Fox Jumps Over The Lazy Dog

The sample above is just an illustration but the real application that I am making consists of large "Remarks" per row.

Please help, and thanks.

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-18 : 20:06:43

Have a look at the following technique. It can be applied to your situation.

http://www.sqlteam.com/item.asp?ItemID=11021

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-03-19 : 12:31:20

And here's another way using COALESCE: http://www.sqlteam.com/item.asp?ItemID=2368

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources