Need to Join 2 Fields from Same Table for a View

• Bravoland

  SSC Enthusiast

  Points: 100

  More actions

  March 9, 2005 at 2:23 pm

  #164809

  Newbie Here..

  i have 2 fields.

  IDNUMBER and PRINTCOUNT

  sample data

  123456789 and 01

  i am trying to create a view that will join the two fields into one field for an application to read from

  12345678901

  can someone provide me with some pointers?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  March 9, 2005 at 2:31 pm

  #546240

  assuming both fields are numbers

  Select CAST(IDNUMBER as varchar(15)) + CAST(PRINTCOUNT as varchar(10)) as ConcatenatedField from dbo.MyTable

• Bravoland

  SSC Enthusiast

  Points: 100

  More actions

  March 9, 2005 at 3:53 pm

  #546258

  excellent. works like a charm. thank you