• As others have mentioned, a sort is not the only option, and the NULL may or may not come first... No one actually showed this yet, though, so here you go:

    SELECT 1 UNION SELECT NULL UNION SELECT '1'

    OPTION (HASH UNION)

    --
    Adam Machanic
    whoisactive