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 and the LIKE clause

Re: Case sensitivity and the LIKE clause

From: Greg Robocker <grobocker_at_paladindata.com>
Date: Tue, 18 May 1999 14:05:07 -0700
Message-ID: <2Hk03.54$S6.13499@news.uswest.net> 





Use:


upper(ProdName) LIKE '%CHI%'



Upper will convert values to upper case before comparing them to the
template



Greg R


Received on Tue May 18 1999 - 16:05:07 CDT












Original text of this message













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