Access mdb, SQL, binary compare = strange results

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Patrick Weidener <pawei_nospom@xxxxxxx>
Date: Fri, 12 Sep 2008 01:44:10 +0200

"SELECT imageguid,imagedevname,id,imagedevname FROM images WHERE STRCOMP(imagedevname='" & SQLExpr(Trim(sTitle)) & "',0)=0")

SQLExpr is just a function that wraps apostrophes.

When sTitle is 'a', but there is only 'A' as an "imagedevname" then my adodb.recordcount should be 0, shouldn't it?
This drives me crazy. The adodb.recordset is filled with the craziest return values like imagedevname 'hell'. 'Hell' for example exists, but I thought I would not be returned when I ask for a binary comparision equal to 'a'....

Can somebody help?
Thank you.
.

Follow-Ups:
- Re: Access mdb, SQL, binary compare = strange results
  - From: Douglas J. Steele

Prev by Date: Re: Error Message: Can't find Installable ISAM
Next by Date: Re: Error Message: Can't find Installable ISAM
Previous by thread: VB - Jobs, Interview Questions, Certification
Next by thread: Re: Access mdb, SQL, binary compare = strange results
Index(es):
- Date
- Thread