Hello, I've created a query in A

[Guest_imported]

Hello,

I've created a query in Access2000.
This is the query:

SELECT codes.CODE
FROM codes
WHERE (((codes.CODE)="aDss&quot);

I get "adss", "Adss", "ADss", ... as result.
I just want the records where the code is "aDss".
Is it possible to create a case sensitive query?

Thanks!

 

[tlbroadbent]

Access is case insensitive as is Jet SQL. Tiy can use a VB function in a query to perform a case sensitive search.

SELECT codes.CODE
FROM codes
WHERE InStr(1,

,"aDss",0)[/b];

The last parameter of the InStr function is the Compare option. 0 indicates binary comparison. Terry L. Broadbent
[COLOR=maroon]Programming and Computing Resources
[URL unfurl="true"]http://tlbroadbent.home.attbi.com/prog.htm[/URL][/color]