Address concatenation

Question

Eno ename addr1 addr2 addr2 city state 1 aaaa xxxx yyyy zzzz tttt rr 2 bbb yyyy zzzz aaaa jjjj rr

output should look like below

eno ename address

1 aaaa xxxx yyyy zzzz tttt rr

2 bbbb yyyy zzzz aaaa jjjj rr

Answer 1

0

Is this what you're looking for?

CREATE TABLE #temp (
 id INT
 , NAME VARCHAR(50)
 , addr1 VARCHAR(50)
 , addr2 VARCHAR(50)
 , addr3 VARCHAR(50)
 , city VARCHAR(50)
 , STATE VARCHAR(50)
 )
GO

INSERT #temp (
 id, NAME, addr1, addr2, addr3, city, STATE
 )
SELECT 1, 'aaaa', 'xxxx', 'yyyy', 'zzzz', 'tttt', 'rr'
UNION
SELECT 2, 'bbb', 'yyyy', 'zzzz', 'aaaa', 'jjjj', 'rr'
GO

SELECT id
 , NAME
 , addr1 + ' ' + addr2 + ' ' + addr3 + ' ' + city + ' ' + STATE AS 'Address'
FROM #temp
GO

answered Sep 16 '12 at 06:14 PM

JohnM
4.5k ● 1 ● 3 ● 7

(comments are locked)

Address concatenation

Follow this question

Related Questions