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 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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
>...
|
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...
|
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...
|
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.
|
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...
|
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...
|
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
|
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...
|
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
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
| |