Help me please!!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Susie
    #1

    Help me please!!

    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?
    Tags: None
    • Jim Kennedy
      #2
      Re: Help me please!!


      "Susie" <susannahbrowni ng@lycos.comwro te in message
      news:e090d470.0 406160750.37da3 293@posting.goo gle.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


        Comment

        Previous template Next
        Working...