How can I run a case-sensitive query in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am runninf Access 2003. When I run queries looking for "Sally" I get
records returned that have "sally" as well as "Sally" and "SALLY". How can I
make my query be case-sensitive?
 
You must use the StrComp function:

WHERE StrComp([FirstNameField], "Sally", 0) = 0

--
John Viescas, author
"Building Microsoft Access Applications" (Coming Soon!)
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top