Re: Searching for text in a Long

In article <91031.adizon_at_mail.us.net>, adizon_at_mail.us.net says...
>
>On Fri, 29 Nov 1996 15:19:52 -0800,
>John Homeyard <homeyard_at_worldnet.att.net> wrote:
>
>>Angelito Dizon wrote:
>>>
>>> What is the best way of SELECTing rows that contain a given text
>>> string in a Long column?
>>>
>>> If the column were not a Long then I could do this:
>>>
>>> SELECT * FROM mytable WHERE mycolumn LIKE %text%
>>>
>>> Thanks,
>>> Lito
>>>
>>> Lito Dizon
>>> adizon_at_us.netYou may be between a rock and a hard place. Long
 columns may not be used
>>in functions arguments, expressions or where clauses.
>>
>>John.
>>
>>
>
>
>Does that mean then that there's no solution here?
>
>Lito
>
>Lito Dizon
>adizon_at_us.net
>

The only way seems to use Oracle ConText option

-- 
Laurent CITTON       (citton_at_shom.fr)
E.P.S.H.O.M          (www.shom.fr)
13 rue du Chatellier
BP 426
29275 BREST cedex
FRANCE