• 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