[thesite] meta description

Warden, Matt mwarden at mattwarden.com
Mon Jan 21 15:56:57 CST 2002

On Jan 21, .jeff had something to say about RE: [thesite] meta description

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

no, i tried that a few days ago when i was playing around with dbms_lob on
the test db. it gives an invalid type message of some sort. I guess you
can't use LOWER() on that type of field.



More information about the thesite mailing list