Re: How to make filter case sensitive?

On Fri, 12 Jan 2007 11:33:01 -0800, Andrew <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ Hello, friends,
¤
¤ I am using VB6 and ADO 2.5 to query an Access database. I am using filter to
¤ get the records I need:
¤
¤ recSet.Filter = "gbkeycode = '" & keyCodeStr & "'"
¤
¤ However, this filter is NOT case sensitive. As a result, I got wrong records.
¤
¤ How to make this filter case sensitive? Thanks a lot.
¤

Access doesn't support case sensitive searches. In a SQL query you can use the StrComp function but
I don't know that this will work with the Filter method (which is somewhat functionally limited to
begin with).


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: SQL to query file system
    ... As I found the status of the catalog in "Computer Management" changes from ... 2003 has rtf filter built-in or do I need to download the filter from ... ¤ Thanks for your link. ...
    (microsoft.public.vb.database.ado)
  • Re: SQL to query file system
    ... Now I can query the file system using full-text search. ... I would also like to search the .rtf files. ... 2003 has rtf filter built-in or do I need to download the filter from ... ¤ Thanks for your link. ...
    (microsoft.public.vb.database.ado)
  • Re: How to make filter case sensitive?
    ... ¤ ... this filter is NOT case sensitive. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.vb.database.ado)
  • Re: How to make filter case sensitive?
    ... ¤ get certain records I need after filling up a record set: ... this filter is NOT case sensitive. ... there is no support for case sensitivity in Access. ...
    (microsoft.public.vb.general.discussion)
  • Re: Filter the filter adodc
    ... ¤ i am new in vb so take it easy:)..and dont laugh.. ... Can we filter the filter with adodc? ...
    (microsoft.public.vb.database.ado)