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: 22599
More actions
December 11, 2009 at 6:19 am
#1091111
Also a void string take 1 CHAR:
SET CONCAT_NULL_YIELDS_NULL ON
SELECT ISNULL('abcd'+''+null,'1234567890')
Result: 123456