ADOQuery with Access always CaseInsensitive ?.

From: Jan Terhechte (jan.terhechte_at_t-online.de)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 12:45:24 +0100

How can I reach an case-sensitive behavior with MS-Access and ADOQuery ?.
I want to differ beetween SELECT * FROM CUSTOMER WHERE NAME = 'Smith'
and SELECT * FROM CUSTOMER WHERE NAME = 'smith' !.

Jan, Germany

Relevant Pages

  • Re: (NDC) Wave Bye-Bye to your precious NSA "Controversy"
    ... Chunk plays a relayer of National Review propaganda on the net. ... anyone who actually bothered to look up the case can affirm, Smith v. ... Maryland was from 1979, not 1978. ... the customer solely by virtue of the carrier-customer relationship" ...
    (rec.music.gdead)
  • Re: Modeling/Constraint question
    ... What is the role they play in my data model? ... then the customer ids will be DUNS or other ... I want to be able to actually find Bruce Smith in the real world. ...
    (comp.databases.ms-sqlserver)
  • Re: Modeling/Constraint question
    ... Smith, to the organisation involved in the transaction. ... I have one from a local bookstore that says I am customer number ... Create a new account using the new address (most people probably do ... Log in to my account (or call Amazon) using my old email address ...
    (comp.databases.ms-sqlserver)
  • Re: Customer List Variations
    ... I have done it numerous times. ... A common problem that arises is that Mrs. Smith's is Mrs. Joe Smith and Mrs. ... Every customer list data-entry variation creates a new listing. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Buyer Beware: ADI of Texas Pinball Bad Seller
    ... Christopher Hutchins wrote: ... reflect on me.Do you ask Smith and Wesson how they like people using ... customer but I just read: Yes, Gary is a douche-bag but he pays me so I ...
    (rec.games.pinball)