Home Forums Article Discussions Article Discussions by Author Discuss content posted by Arto Ahlstedt How long is a NULL? RE: How long is a NULL?
Carlo Romagnano
SSC-Insane
Points: 22602
More actions
December 11, 2009 at 8:34 am
#1091220
The question is:
it is a BUG?
... or it is by design?
... or both: it is a BUG by design!
Try this:
DECLARE @v-2 char(10)
SET CONCAT_NULL_YIELDS_NULL ON
SELECT ISNULL('abcd'+@v,'1234567890')
RESULT: 1234567890
This behavior is all right!