Concatenation of two columns with hyphen

Question

Post reply

Concatenation of two columns with hyphen

bharathi-903755

SSC-Addicted

Points: 425
More actions
November 30, 2008 at 11:16 pm

#154967

Hi
I have two columns in my table:
ID(Bigint),NAME(VARCHAR)
i need to concatenate these two with a hyphen in between.
Can anyone help me on this??
Thanks,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Select Cast(ID as varchar(18)) + '-' + NAME

From YourTable

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

bharathi-903755 SSC-Addicted Points: 425 More actions · Answer 2

bharathi-903755

SSC-Addicted

Points: 425

November 30, 2008 at 11:39 pm

#905394

Thanks..

brainy SSCrazy Points: 2445 More actions · Answer 3

Check this... I think it will help you

declare @a bigint

declare @b-2 varchar(10)

declare @C varchar(100)

set @b-2 = 'test'

set @a = 5

set @C = @b-2 +'-' + cast(@a as varchar(50))

print @C

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 4

Gouthama Kolivad (12/1/2008)
Check this... I think it will help you
declare @a bigint
declare @b-2 varchar(10)
declare @C varchar(100)
set @b-2 = 'test'
set @a = 5
set @C = @b-2 +'-' + cast(@a as varchar(50))
print @C

Already suggested 😉

Madhivanan

Failing to plan is Planning to fail