Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Case Sensitivity in Oracle for NT

Re: Case Sensitivity in Oracle for NT

From: Elliot Ross <eross#_at_serviceware.ca>
Date: 1997/06/23
Message-ID: <MPLANET.33aa97cbeross#98969f@news.magma.ca>#1/1

Thank you, I was hoping that was not the case as all the SQL is being generated by MFC through VC++

thanks !

In article <33A6CBF7.8F76E0C2_at_rnix.com>, nix_at_rnix.com says...
> try:
> where upper(c_name) = 'SMITH'
> > Can anyone explainn how to have Oracle sort case insensitive ?? I am
> > trying to have tables (such as Customers) that sort case insensitive.
> >
> > If I do a select ... from .... Where C_NAME = SMITH etc.
> >
> > I want to get SMITH, Smith, smith, sMitTh etc and so on !!
> _____________
> Robert C. Nix
> mailto:nix_at_rnix.com
> http://www.rnix.com
> my opinions are not necessarily those of my employer
>
 

-- 
My EMail address contains a # to try to 
thwart mail spamming. 
Received on Mon Jun 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US