Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: How long is a NULL?

    logic is here...

    SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('1234'+NULL,'1234567890')

    =>> 12345

    SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('1234'+NULL,'1234567890')

    =>> 12345

    SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('1234'+NULL+Null,'1234567890')

    =>> 123456

    SET CONCAT_NULL_YIELDS_NULL ON

    SELECT ISNULL('1234'+NULL+Null+Null,'1234567890')

    =>> 1234567

    ---

    Logic >> '1'+'2'+'3'+'4'+'\0'+'\0'+'\0'

    December 23, 2009 at 6:36 am

    #1095889

Viewing post 1 (of 1 total)