Re: Case insensitivity in LIKE query - possible?

From: Randy Dewoolfson <randyd_at_cais3.cais.com>
Date: 1996/04/02
Message-ID: <4js72v$80e_at_news2.cais.com>#1/1


James P. Cooper (pixel_at_rhino.coe.missouri.edu) wrote:

: Hello,
 

: I'm using Oracle 7.1 on an SGI, and would like to perform some case
: insensitive queries using LIKE. I've looked through several SQL books,
: and have found nothing addressing the subject. Can this be done?
 

: Currently the query:
 

: SELECT * from foo where name LIKE 'James';
 

: will match:
 

: James
: James Cooper
 

: but not:
 

: JAMES
 
: ...
 

: Any suggestions appreciated.
 

: -- James
 

: .........................................................................
: James Paul Cooper * Pixel
: MU College of Education
: pixel_at_coe.missouri.edu - http://tiger.coe.missouri.edu/~pixel/
: .........................................................................

try this
SELECT * FROM foo WHERE UPPER( name ) LIKE '%NAME%';

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I
Received on Tue Apr 02 1996 - 00:00:00 CEST

Original text of this message