column values into one string in sql stored procedure

Question

I have and address table with the following columns:

addressId
buildingName
streetNo
streetName
streetType
subAddressNo
subAddressType
suburb
postCode
state

What I want is to SELECT * from address where addressId = @addressId, and that return would be all columns concatenated into one string. Something like:

set @addressString = (SELECT * from address where addressId = @addressId)

t-clausen.dk · Accepted Answer · 2011-08-15 08:25:27Z

4

select coalesce(cast(addressId as varchar)+ ',', '')  + coalesce(buildingName+ ',', '') 
coalesce(cast(streetNo as varchar)+ ',', '') -- + and so on 
from address

remember to cast the numeric types as varchar

edited Aug 15, 2011 at 8:25

answered Aug 15, 2011 at 8:15

t-clausen.dk

44.5k12 gold badges61 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

score 0 · Accepted Answer · 2011-08-15 03:08:56Z

0

Try this:

SELECT buldingName + ' ' + streetNo + ' ' + streetName + ' ' + theRestOfYourColumns AS ClientAddress
FROM YourAddressTable
WHERE addressId = @addressIdPreviouslyAssignedVariable

edited Aug 15, 2011 at 3:08

answered Aug 15, 2011 at 3:03

user596075

1 Comment

user596075 Over a year ago

I know this probably goes without saying, but I just didn't type out all of the column names, but use any configuration you would like.

Collectives™ on Stack Overflow

column values into one string in sql stored procedure

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related