[thesite] meta description

[.jeff]

dean,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 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

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/