Concat vs Overwrite

Results 1 to 2 of 2

Thread: Concat vs Overwrite

  1. #1
    Join Date
    Dec 1969

    Default Concat vs Overwrite

    Is there a way, through SQL, to perform an update that instead of replacing a nvarchar field, it will concatenate the new data?<BR><BR>I can, if it comes to this, first, select the existing data, then concatenate it to the new data through the code, but I would like to minimize the amount of hits to the database I end up making.<BR><BR>Any ideas are greatly appreciated!<BR><BR>-Kevin

  2. #2
    Join Date
    Dec 1969

    Default RE: Concat vs Overwrite

    update mytable<BR> set mycol = mycol + &#039;stuff&#039;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts