Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Unanswered: Concatenated long varchar fields are getting truncated

    (I'm using MS SQL 2000)

    I've two tables that I've made from some query subsets. Each table has a varchar field with notes/memos and I want to concatenate the fields into one long field.

    The problem I'm running into is that when I run the query to check the concatenation, the field is truncated maybe 256 chars in.

    I tried converting and casting the field as nvarchar 4000, and I've also done the same for the fields in the two tables, but that doesn't seem to help.

    I can query for the fields from each table and none of them are truncated by themselves. It only happens after I concatenate them.

    I've created a new table and inserted the results into it, but the field in it is also truncated.

    Am I missing something obvious here?

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    Go to QA Tools/Options/Results and change Maximum characters per column to 8192.

  3. #3
    Join Date
    Mar 2004

    I knew I was missing something simple.


Posting Permissions

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