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 NULLbecause something + NULL = NULL in 8.0
if you initialize @.FooterLine to '' or something else you won't have this problem.|||HAHA, thats right. Thanks.
Showing posts with label light. Show all posts
Showing posts with label light. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)