SQL "Where" condition can be case sensitive ?

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by pepito perez Thu, 11 Jan 2001 12:54

#917

Author: pepito perez
Date: Thu, 11 Jan 2001 12:54

11 lines
1132 bytes

Hi Everybody,

In SQL Standard, I have a query like this:

select name,addres from agentes,users where name = identification

If name is "PETER" and identification is "peter" this query returns the
register. I�d like to make the query case-sensitive.
Any idea ?

Thank you in advance.

Re: SQL "Where" condition can be case sensitive ?

#834

Author: Kim Hellan
Date: Tue, 16 Jan 2001 08:21

9 lines
1254 bytes

I don't think you can make your query case sensitive, if your database does
not support case sensitivity.
I don't know what database you are using, but for example MS Access 97 does
not support case sensitivity.

Kim Hellan

> If name is "PETER" and identification is "peter" this query returns the
> register. I�d like to make the query case-sensitive.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads