Case Sensitive query

[crashevans]

Hi

I want to search a table for a case sensitive result e.g. "Blue", however it currently returns this result whether I search for BLUE, blue etc. I am using Microsoft Access.

The query I tried -
SELECT * FROM User WHERE Password = 'Blue'

Thanks for help in advance.

 

[DrSimon]

I don't think there's an easy way of doing this.

I've created this function to convert the text into binary equivalent:

Function TextToBinary(Str As String) As String
Dim L As Integer
For L = 1 To Len(Str)
    TextToBinary = TextToBinary & Asc(Mid(Str, L, 1))
Next L
End Function

Then the query is: [blue]
SELECT * FROM User WHERE (TextToBinary[Password]=66108117101) [/blue]

Where '66108117101' is the concatened binary equivalent of 'Blue'. Obviously if it isn't actually 'Blue' you would need to work out the appropriate code (use the function Asc if you don't know how to do that)

Simon Rouse

 

[PWise]

try

SELECT * FROM User 
WHERE Strcomp("Blue",[Password],vbBinaryCompare)=0

 

[DrSimon]

Thanks pwise - I was wrong, forgot about StrComp!

 

[crashevans]

Yes cheers works fine!