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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

paramter query 2
Show 0 instead of Null 1
cleaning up duplicative data table 1
help with query 1
Complex query question? 1
Query to Count Consecutive days? 16
problems getting value in crosstab fashion in Sql server 2000 1
Query problem.. 1

Back
Top