[thesite] meta description

.jeff jeff at members.evolt.org
Mon Jan 21 12:56:09 CST 2002


> From: Dean Mah
> DBMS_LOB is a standard Oracle package.  I use it
> currently to search the tip bodies.  It's as simple
> as adding:
>    DBMS_LOB.INSTR(column, search_string) <> 0
> to your queries.  Unforuntately, this is a
> case-sensitive search.

can you force it to a case-insensitive search by wrapping the column
reference with a Lower() function?  for example:

DBMS_LOB.INSTR(Lower(column), '#LCase(search_string)#') <> 0



jeff at members.evolt.org

More information about the thesite mailing list