Re: Case insensitivity in LIKE query - possible?
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===IReceived on Tue Apr 02 1996 - 00:00:00 CEST