[thesite] meta description

[Warden, Matt]

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

>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

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.

hth,

--
mattwarden
mattwarden.com