Post reply

Missing data

  • March 12, 2007 at 7:13 am

    #171622

    I have a union query not returning the entire contents of a field.  Both A_COMMENT and B_TEXT are defined as varchar with a length of 4000.  I have data in B_TEXT totaling 1297 characters but my query results are only returning the first 1015 characters.  Any ideas???

     

    SELECT A_COMMENT "COMMENT" FROM GPROC_HISTORY

    union all

    SELECT B_TEXT "COMMENT" FROM BACTIVE_COMMENT

  • March 12, 2007 at 8:17 am

    #694394

    If you're using Query Analyzer, it's possible that your Maximum characters per column setting is set to display only 1015 characters.  Go to Tools -> Options -> Results tab and check the Maximum characters per column field.

  • March 12, 2007 at 8:30 am

    #694396

    Problem solved!  Thank You

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply