• This works OK in SQL server 2000.

    The question didn't specify which SQL version.

    😎