Case senstive order by

Results 1 to 2 of 2

Thread: Case senstive order by

  1. #1
    Join Date
    Dec 1969

    Default Case senstive order by

    I posted the question yesterday on case sensitive select, or more exactly, case sensitive order by on SQL Server and Access.<BR><BR><BR>My question is how to select and return records so that the resultset will be in case senstive order, ie, upper case comes before lower case.<BR><BR>Response from ks suggests using<BR>...order by ASCII(SUBSTRING([Field1],1,1)),ASCII(SUBSTRING([Field1],2,1)),ASCII(SUBSTRING([Field1],3,1)),[Field1]<BR><BR>This somehow works but only on SQL Server. Does anyone know of a corresponding ASCII function in Access. I&#039;ve tried Asc() but doesn&#039;t work. Or does anyone have any idea on doing a case sensitive order by? All suggestions are greately appreciated. Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Use


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts