Re: Searching for text in a Long

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 Received on Sun Dec 01 1996 - 00:00:00 CET