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

Home -> Community -> Usenet -> c.d.o.server -> Contains and case insensitive

Contains and case insensitive

From: Oliver Huppert <Oliver.Huppert_at_pikon.com>
Date: Fri, 21 Sep 2001 10:11:20 +0200
Message-ID: <9oesg4$l8j$1@piesbach.saarnet.de> 





Hi all,



the Function "contains" is case insensitive.



select * from table where contains(text, 'hallo')
returns only 'hallo', but it should return also 'HALLO', 'Hallo' or
something like that.


(the "text"-field is a long on Oracle 8i)
Someony knows what I could do??



Regards


Olli
Received on Fri Sep 21 2001 - 03:11:20 CDT












Original text of this message













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