Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Unanswered: sp_option... 'concat null yields null'

    I'm trying to set the concat... option to OFF
    all the time and in all my databases

    I tried this command

    USE master
    EXEC sp_dboption 'DatabaseName', 'concat null yields null', 'FALSE'

    but it doesn't change anything

    Select NULL + 'TOTO'
    ----> NULL

    (it should be 'TOTO')

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Any way you can pepper your code with isnull()'s?

    as in

    select isnull(null, '') + 'toto'

  3. #3
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    yes

    but it's a migration pb
    all queries were written for SYBASE

    and I have to re-check all queries for possible NULL concatenation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •