473,322 Members | 1,718 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

case never match

Dear all,

I am using Access2000. There is a table with field X, which possible values
are 'A','a','B','b'.

However I found all text comparison in Access is case-insensitive. For
example, where X="A" will give me both 'A' and 'a' records. When using
group by X, only 2 rows with X='A' and 'B' are returned. All 'a' and 'b'
records are count into the group of 'A' and 'B'.

Why Access works this way and any option to make all comparison become
case-sensitive?

TIA

Leo Chan
Nov 12 '05 #1
2 1260
Leo Chan wrote:
Dear all,

I am using Access2000. There is a table with field X, which possible values
are 'A','a','B','b'.

However I found all text comparison in Access is case-insensitive. For
example, where X="A" will give me both 'A' and 'a' records. When using
group by X, only 2 rows with X='A' and 'B' are returned. All 'a' and 'b'
records are count into the group of 'A' and 'B'.

Why Access works this way and any option to make all comparison become
case-sensitive?

You can use StrComp(). Or call it from a module and set the first line
to Option Compare Binary. Read the help topic on Option Compare.

Nov 12 '05 #2
Dear Salad,

Thanks it works. However quite some of query has to be modified to use the
function.

Rgds
Leo
"Salad" <oi*@vinegar.com> wrote in message
news:m8******************@newsread2.news.pas.earth link.net...
Leo Chan wrote:
Dear all,

I am using Access2000. There is a table with field X, which possible values are 'A','a','B','b'.

However I found all text comparison in Access is case-insensitive. For
example, where X="A" will give me both 'A' and 'a' records. When using
group by X, only 2 rows with X='A' and 'B' are returned. All 'a' and 'b' records are count into the group of 'A' and 'B'.

Why Access works this way and any option to make all comparison become
case-sensitive?

You can use StrComp(). Or call it from a module and set the first line
to Option Compare Binary. Read the help topic on Option Compare.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Brian van den Broek | last post by:
Mark Devine said unto the world upon 2004-12-16 10:49: > Hi I'm brand new to python and I was wondering if anybody knew of a > easy way to change every character in a list into its lower case >...
6
by: Simon Gibson | last post by:
Hi there, im trying to write a program where you can write reports and save them into an array. im having problems with getting the string into an array tho it seems to be skipping over the...
2
by: Pierre | last post by:
Hello, I would like to write a regexp that can be either case sensitive or that can ignore the case based on a variable (value would be either 'i' or ''). For instance in the below code the...
7
by: Lauren Quantrell | last post by:
Is there any speed/resource advantage/disadvantage in using Select Case x Case 1 Case 2 etc. many more cases... End Select VS.
5
by: Alan Silver | last post by:
Hello, I've just spent ages debugging some cookie code that wasn't working, and have finally discovered that the code *was* working, but that the path used by cookies is case-sensitive. I was...
110
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst...
7
by: Christopher Nelson | last post by:
In Bourne shell, you can do: case ($x) in foo*) ;; *bar) ;; esac so that the first case matches any string starting with "foo", the
6
by: ccsoupy22 | last post by:
For simplicity sake, here are the basics of the query I am stumped on... Type: Select query Name: ColorCells Below is a partial list of the "Cases" for the code (I did not think there was...
3
by: =?Utf-8?B?Qm9i?= | last post by:
How can I use RegEx to search for a number of strings and replace them with upper case versions of themselves? Thanks
6
by: Derik | last post by:
Okay, I THINK this is a PHP question... I've been mucking with PHP for awhile now, but just recently I've been poking at some ajax stuff, and I ran into something confusing; my Queries were...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.