Text data.

• Mkumari

  Hall of Fame

  Points: 3498

  More actions

  May 17, 2004 at 10:21 am

  #111238

  I am having a problem inserting the data into a text column. The data comes into 2 string variables which are Varchar(8000), what I want to do is I want to insert the data into a text column by concatinating string 1 and string 2. Is there a way I can do it.

  Thanks,

  MK

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  May 17, 2004 at 1:47 pm

  #506697

  Have you tried:

  UPDATE tablename

  SET columnname = @variable1 + @variable2

  -SQLBill