CASE vagaries

  • The title of the question has nothing to do with the trick question with the IsNULL() function and the variable length. The question only proves that IsNull is using the variable of the first parameter.

    /HΓ₯kan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • Hugo Kornelis (9/9/2013)


    david.gwalter (9/8/2013)


    Bottom line - if you look at QotD as a way to learn, then always check the discussion on the boards!

    I find this to be very true even when the answers are correct. I always learn something from you and others who amplify on the answers.

    I do look at the question of the day as a way to learn. So, even when I get it wrong, I still win because I have learned something.

  • Revenant (9/10/2013)


    I am glad I got to answer this one after it was corrected. πŸ˜‰

    Ditto

  • KWymore (9/9/2013)


    Miles Neale (9/9/2013)


    Ross.M (9/9/2013)


    Steve Jones - SSC Editor (9/9/2013)


    I have updated the answers and awarded back points.

    I was just about to say, don't know what everyone is talking about, the correct answer is there, I even double checked it in SSMS! Thanks Steve.

    +1 Some times it pays to come late to the game.

    πŸ˜€

    +1

    +1

    makes at least +2 πŸ™‚

    Well, in the corrected version: Interesting question!

    ________________________________________________________
    If you set out to do something, something else must be done first.

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply