Access2002: Case sensitive or insensitive?

[Samik Raychaudhuri]

Hello,
I have rows in a table with names like 'Harish', 'Harini' and 'Narahari'. When I write a query like:
SELECT * FROM members WHERE name like '*hari*';
it selects only the 3rd record. I thought Access is case insensitive (and I want to select all 3). Am I going wrong somewhere?
I am using OfficeXP (Access 2002).
Thanks and regards,
-Samik
--
Samik Raychaudhuri
University of Wisconsin, Madison
http://samik.freeshell.org/

To email me, replace 'K' with 'e' in the 'From' field.

 

[Cheryl Fischer]

Can you supply more detail as to how you are using this SQL string? I am
using Access 2002 on Windows XP Pro and have plugged your sample values into
a table with a field called Name. In Design View of a query, your sql
string produces 3 records. Using your sql string as the RecordSource of a
form also returns 3 records.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hello,
I have rows in a table with names like 'Harish', 'Harini' and 'Narahari'. When I write a query like:
SELECT * FROM members WHERE name like '*hari*';
it selects only the 3rd record. I thought Access is case insensitive (and

I want to select all 3). Am I going wrong somewhere?

 

[Samik Raychaudhuri]

Actually I am using Access2002 as a frontend to a Postgresql database. I have linked the tables through ODBC DSN using the File -> Get External Data -> Link Tables command. Now when I am trying to use this, I am getting struck.
I also tried w/ a new table and putting those values, as you said, and I got all 3 records. But I get only one (corresponding to 'Narahari') when I use the same query in the original db.
I thought once the data is opened, MsAccess works as usual, but that doesn't seem so. Any ideas?
Thanks.
-Samik

Can you supply more detail as to how you are using this SQL string? I am
using Access 2002 on Windows XP Pro and have plugged your sample values into
a table with a field called Name. In Design View of a query, your sql
string produces 3 records. Using your sql string as the RecordSource of a
form also returns 3 records.



--
Cheryl Fischer
Law/Sys Associates
Houston, TX



When I write a query like:


I want to select all 3). Am I going wrong somewhere?

--
Samik Raychaudhuri
University of Wisconsin, Madison
http://samik.freeshell.org/

To email me, replace 'K' with 'e' in the 'From' field.