473,529 Members | 2,206 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Case insensitive filter in MS Access front end

I'm using Oracle 8.1.7 on a linux server. I'm using ms access 2002 as a
front end to connect to the dbserver with the oracle ODBC driver on a
win2k machine.

When I use the filter functionality inside MS Access to look up a
record, the result is case-sensitive (I guess because oracle itself is
case-sensitive).

Is there a way that I can use the filter inside MS Access to look up
records in a case-insensitive way?

Jan Bols

Nov 12 '05 #1
2 7200
Only if the database is case-insensitive.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Jan Bols" <ja*@ivpv.ugent.be> wrote in message
news:bo**********@gaudi2.UGent.be...
I'm using Oracle 8.1.7 on a linux server. I'm using ms access 2002 as a
front end to connect to the dbserver with the oracle ODBC driver on a
win2k machine.

When I use the filter functionality inside MS Access to look up a
record, the result is case-sensitive (I guess because oracle itself is
case-sensitive).

Is there a way that I can use the filter inside MS Access to look up
records in a case-insensitive way?

Jan Bols

Nov 12 '05 #2
On Wed, 05 Nov 2003 14:59:03 +0100, Jan Bols wrote:
I'm using Oracle 8.1.7 on a linux server. I'm using ms access 2002 as a
front end to connect to the dbserver with the oracle ODBC driver on a
win2k machine.

When I use the filter functionality inside MS Access to look up a
record, the result is case-sensitive (I guess because oracle itself is
case-sensitive).

Is there a way that I can use the filter inside MS Access to look up
records in a case-insensitive way?


I always use pass-through queries and clauses like e.g.
WHERE UPPER(FieldName) LIKE '%XYZ%'

Peter

--
No mails please.
Nov 12 '05 #3

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

Similar topics

1
4408
by: noah | last post by:
Can anyone think of a way to make array keys case insensitive? An option on any recent PHP would be to convert all array keys to lowercase using the standard array_change_key_case() function. As it turns out, I'm stuck on a PHP 4.1.3 system, so that function is not available to me. Can anyone think of an efficient way to write my own version...
32
3114
by: Elliot Temple | last post by:
Hi I have two questions. Could someone explain to me why Python is case sensitive? I find that annoying. Also, why aren't there multiline comments? Would adding them cause a problem of some sort? Thanks, Elliot
5
18446
by: Madjid Nasiri | last post by:
Hi, I am basic in oracle. My Old programs write with Delphi and Databases: Access, Paradox, MySQL, Microsoft SQL. I write my code (SQL code) case-insensitivae, but now i need use oracle database. The Oracle by default is case-sensitive, How can used case-insensitive in oracle. Thanks Madjid Nasiri
6
9905
by: Steve | last post by:
I have a query which filters records containing uppercase and Lowercase i.e. Smith and SMITH, Henderson and HENDERSON etc. Is there a way that I can filter only those records that contain the first uppercase letter and the remaining lowercase letters for my query i.e. Smith , HENDERSON etc. Thanks
2
10298
by: Tom | last post by:
Hi, Our development team is adding DB2 8.1 compatibility to our existing application which currently supports SQLServer 2000. Our code is written to take advantage of SQLServer's ability to allow query string compares to be case insensitive. We have identified DB2 forces all query string compares to be evaluated case sensitive. Since...
1
4301
by: Julia | last post by:
Hello there. I have a question somewhat related to this topic, and I don't know where else to go. I hope somebody can help. I've created a database in access, that I'd like to share with less than 10 users. I'd like each user to see only some of the records in the database. So for example, if I have eight users in eight countries, I...
3
1147
by: Jason Tesser | last post by:
I am converting data from Access into Postgres and ran into an issue with case sensitivity. Can I write queries in Access that will be case insensitive without rewriting the queries. So I would like to know if this be handled in Postgres or even if someone knows in Access. Thank you.
7
3318
by: Adrian | last post by:
Hi, I want a const static std::set of strings which is case insensitive for the values. So I have the following which seems to work but something doesnt seem right about it. Is there a better way or any gotcha's from my code below.
0
5030
by: J. Cliff Dyer | last post by:
Please keep the discussion on-list. On Fri, 2008-09-05 at 15:36 +0200, Maric Michaud wrote: That does not get the same behavior as the OP's original solution. The OP's solution retrieves the first matching value only. Mine gets one arbitrary matching value, determined by the algorithm used for constructing the search dict (not specified...
0
7508
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
5809
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5199
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4835
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3335
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1719
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
902
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
567
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.