From: kennedy-downwithspammersfamily@attbi.net   
      
   "Susie"  wrote in message   
   news:e090d470.0406160750.37da3293@posting.google.com...   
   > I'm trying to search a CLOB field Case insensitively.  I'm currently   
   > using dbms_lob.instr() to search, but this function is case sensitive.   
   >  Does anyone have an idea on what I can use here?   
   If it is a whole word then Intermedia.  Else you have to uppercase (or   
   lowercase) the two items and compare.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)