[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
>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
More information about the thesite
mailing list