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,

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  November 30, 2008 at 11:24 pm

  #905390

  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

  November 30, 2008 at 11:39 pm

  #905394

  Thanks..

• brainy

  SSCrazy

  Points: 2445

  More actions

  December 1, 2008 at 1:15 am

  #905403

  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

  December 1, 2008 at 4:01 am

  #905451

  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