Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187

    Unanswered: 6.5 vs 8.0 query output. Please shine some light.

    Hi guys,
    Quick question (I hope).
    Why is there a difference in the output of this query in 6.5 campatibility vs 8.0 campatibility?

    DECLARE @FooterLine varchar(30)

    select @FooterLine = rtrim(@FooterLine) + 'Run by Region'

    select @footerline

    6.5 returns Run by Region
    8.0 returns NULL

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    because something + NULL = NULL in 8.0

    if you initialize @FooterLine to '' or something else you won't have this problem.

  3. #3
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    HAHA, thats right. Thanks.

Posting Permissions

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