• The answer is clearly wrong. Some of these questions are really questionable.

    The

    isnull(left(@b,3),'I ô Char') as ba

    will also return the string. The left function of @b-2 returns NULL.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3