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?
Jon Cooney
Old Hand
Points: 329
More actions
December 11, 2009 at 1:23 pm
#1091383
SET CONCAT_NULL_YIELDS_NULL ON
DECLARE @STR AS VARCHAR(8)
SET @STR = 'abcdefghij'
SELECT @STR
SELECT LEN(@str)
SELECT LEN(@str+NULL)
SELECT ISNULL(@str+NULL,'1234567890')
--------
abcdefgh
-----------
8
NULL
---------
123456789
Okay.....