Home » Infrastructure » Windows » Case sensitivity
Case sensitivity [message #367157] Mon, 04 September 2000 06:20 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi all,
Is there an idea, how I can solve following problem:

When I'm executing for example:
select * from table where name = 'someting'

The string equal to name is case sensitive. How can I set all this things case insensitive in Oracle server version 8.0.5.0.0 .

Thanx in advance
Laert

Report message to a moderator

Re: Case sensitivity [message #367160 is a reply to message #367157] Fri, 08 September 2000 16:07 Go to previous message
Dave Haas
Messages: 4
Registered: September 2000
Junior Member
Hi Laert.

What you need is:

select * from table where upper(name) = 'SOMETHING'

Cheers,

Dave

Report message to a moderator

Previous Topic: Using Active x automations to Query ORACLE 8.05
Next Topic: Urgent Oracle Services Question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 06:58:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.