upper case & lower case?

[bros]

I found that use index key , or use SQL command to seek a text, that are no case sencitive, which I can have two data of "ABC", "abc", it just found it same as a one record only.
How can I to different the above records, when I seaching them??

I was using access database and vb6.

 

[dpaulson]

If you are using ADO the 'FIND' method is case sensitive.
David Paulson

 

[mainbyte]

I am trying to have case sensitive searches using FIND. Using the code below the searches are NOT case sensitive. I have placed Option Compare Binary in the declarations of the module. I am using access and vb6. Is there some global setting that I am missing somewhere? I am using the * wildcard in the string "mynotes".

thanks

ron


If myfield = "NGC Description" Then
datprimaryrs.Recordset.Find "ngc_descr like " & "'" & mynotes & "'", adSearchForward
End If

 

[dpaulson]

Hi Ron,

When using ADO, any queries using the keyword 'LIKE' uses the '%' as the wildcard. Try that.
David Paulson