Post reply

COLLATE order of NULL

  • May 17, 2010 at 12:19 am

    #219010

    NULL entries should be sorted after the value containing columns and not before when the value containing column that is sorted is sorted ascending

    what collation can be used on ORDER BY statement

    or how can I manipulate an existing collation so that NULL is treaded as behind Z

  • May 17, 2010 at 1:07 am

    #1168125

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic922719-9-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 17, 2010 at 3:01 am

    #1168148

    I am not sure if Access is the reason why it is not working or simply the SQL Server. So please all Access programmers look in the topic under SQL Server 2000 - General. It sure has nothing todo with the SQL Server Version ---- thats a bit confusing here.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply