• Title should have read IsNull and not Is Null. However interesting effect as you found out.

    Example.

    declare @x varchar(5)

    select isnull(@x,'1234567890')

    From BOL

    Arguments

    check_expression

    Is the expression to be checked for NULL. check_expression can be of any type.

    replacement_value

    Is the expression to be returned if check_expression is NULL. replacement_value must have the same type as check_expresssion.

    Keep in mind type is not varchar but the varchar(5). Many folks forget that.