Home Forums SQL Server 7,2000 General Sorting RE: Sorting

  • July 14, 2003 at 7:11 am

    #465300

    If sorting on name for instance, I do the following

    SELECT ID, Name 

    FROM NameType 

    ORDER BY (CASE WHEN Name IS NULL THEN 1 ELSE 0 END) ASC, Name ASC

    Far away is close at hand in the images of elsewhere.
    Anon.