Re: Searching for text in a Long
From: Angelito Dizon <adizon_at_mail.us.net>
Date: 1996/12/01
Message-ID: <91031.adizon_at_mail.us.net>#1/1
Date: 1996/12/01
Message-ID: <91031.adizon_at_mail.us.net>#1/1
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